SQL
AخA
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 = 'Media_from_WikiDaheim_2024_in_Austria/all'
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;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.