SELECT /* SLOW_OK */ DISTINCT actor_name AS user, COUNT(image.img_name) as img_count 

    FROM actor, revision, 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 categorylinks.cl_to = "Uploaded_via_Campaign:WikiDaheim-at-wd" 

        #AND categorylinks.cl_to = "Prejury_selection_for_WikiDaheim_2023_in_Austria" 

    GROUP BY user 

    ORDER BY img_count DESC limit 300;

​

SELECT /* SLOW_OK */ DATE_FORMAT(DATE_ADD(DATE_ADD(img_timestamp, INTERVAL -6 MONTH), INTERVAL 2 HOUR),'%Y') AS date, COUNT(image.img_name) as images

#    FROM image, page, categorylinks

    FROM

    image

    JOIN page ON image.img_name = page.page_title

    JOIN categorylinks ON page.page_id = categorylinks.cl_from

    WHERE

     #page.page_id=categorylinks.cl_from 

     #   AND image.img_name = page.page_title

     #   AND 

        categorylinks.cl_to = "Uploaded_via_Campaign:WikiDaheim-at-wd"

        AND img_timestamp BETWEEN 20220630220000 AND 20231008220000 

    GROUP BY date desc;