WikiDaheim users 2021 (by first revision, by uploader, in prejury)

SQL

SELECT /* SLOW_OK */ DISTINCT actor_name AS user, COUNT(image.img_name) as img_count, COUNT(image2.img_name) as img_count_for_prejury
    FROM actor, revision, image, page, categorylinks, image as image2, page as page2, categorylinks as categorylinks2
    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 categorylinks.cl_to = "Media_from_WikiDaheim_2021_in_Austria/all"
        
        and page2.page_id=categorylinks2.cl_from
        AND actor.actor_id = revision.rev_actor
        AND image2.img_name = page2.page_title
        and revision.rev_page = page2.page_id
        and revision.rev_parent_id = 0
        AND categorylinks2.cl_to = "Media_from_WikiDaheim_2021_in_Austria/all"
        and NOT EXISTS( SELECT * FROM categorylinks as categorylinks3 
		    WHERE page2.page_id=categorylinks3.cl_from 
                  and categorylinks3.cl_to = "Media_from_WikiDaheim_2021_in_Austria_not_for_prejury"
		  )

    GROUP BY user 
    ORDER BY img_count DESC limit 300;
SQL

Checking query status...
