SQL
x
use commonswiki_p;
SELECT concat("[[Special:ListFiles/",img_user_text, "]]") AS username,
COUNT(image.img_name) AS files_count,
user_editcount as edits,
image.img_name as example
FROM image
JOIN user ON img_user_text = user_name
WHERE image.img_name IN (SELECT page_title FROM page
JOIN categorylinks ON cl_from = page_id
WHERE cl_to = "All_media_needing_categories_as_of_2012"
OR cl_to = "All_media_needing_categories_as_of_2013"
OR cl_to = "All_media_needing_categories_as_of_2014"
OR cl_to = "All_media_needing_categories_as_of_2015"
OR cl_to = "All_media_needing_categories_as_of_2016"
AND page_namespace = 6)
GROUP BY img_user_text
ORDER BY files_count DESC
LIMIT 10000;
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.