Total Commons uploads by user (with >500 edits)

Fork of Total Commons uploads by user (with >500 edits) by Prototyperspective

This query is marked as a draft This query has been published by Ranjithsiji.

Published at https://commons.wikimedia.org/wiki/Commons:Commons_contributions_achievements/Commons_contributors_by_number_of_uploads

Number of uploads where the upload is the current version of a file by users that have more than 500 edits

SQL

SELECT actor_name, COUNT(*)
FROM image
JOIN actor_image ON img_actor = actor_id
JOIN `user` ON actor_user = user_id
WHERE user_editcount > 500
GROUP BY img_actor
ORDER BY COUNT(*) DESC

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...