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_2023_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.
Query status: complete
Executed in 37.48 seconds as of Tue, 18 Jun 2024 20:19:52 UTC.