Uploads Tag des Denkmals 2024

SQL

SELECT /* SLOW_OK */ COUNT(image.img_name) as images
    FROM
    	image
        JOIN page AS page_img ON image.img_name = page_img.page_title
        JOIN categorylinks ON page_img.page_id = categorylinks.cl_from
    WHERE
        categorylinks.cl_to like "Tag_des_Denkmals_2024_i%"
        AND img_timestamp BETWEEN 20240630220000 AND 20241006220000 
   ;
   
SELECT /* SLOW_OK */ DISTINCT actor_name AS user, COUNT(image.img_name) as img_count 
    FROM
    	image
        JOIN page AS page_img ON image.img_name = page_img.page_title
        JOIN categorylinks ON page_img.page_id = categorylinks.cl_from
        JOIN revision ON revision.rev_page = page_img.page_id
        JOIN actor ON actor.actor_id = revision.rev_actor
    where
        categorylinks.cl_to  like "Tag_des_Denkmals_2024_i%"
        and revision.rev_parent_id = 0
        #AND categorylinks.cl_to = "Prejury_selection_for_WikiDaheim_2023_in_Austria" 
    GROUP BY user 
    ORDER BY img_count DESC limit 300;
SQL

Checking query status...
