uploads by user by capture date

SQL

USE commonswiki_p;
describe revision;
describe image;
describe actor;
set @actor:='Bwag';

select /* SLOW_OK */ img_name, img_actor, img_timestamp, rev_timestamp, actor_name  from image, revision, actor where
	actor.actor_name = @actor
    and actor.actor_id = revision.rev_actor
    and revision.rev_parent_id = 0
    order by rev_timestamp limit 100;
    
    /*
SELECT DISTINCT actor_name AS user, COUNT(revision.rev_parent_id) as edit_count 
    FROM actor, revision, revision as revision0, image, page, categorylinks 
    WHERE page.page_id=categorylinks.cl_from
        AND actor.actor_id = revision.rev_actor
        AND image.img_name = page.page_title
        and revision.rev_page = page.page_id
        and revision.rev_parent_id > 0
        and revision0.rev_parent_id = 0
        and revision.rev_page = revision0.rev_page
        and revision.rev_actor != revision0.rev_actor
        AND categorylinks.cl_to = "Media_from_WikiDaheim_2020_in_Austria/all" 
    GROUP BY user 
    ORDER BY edit_count DESC limit 200;
    */
SQL

Checking query status...
