Replicas browser and optimizer
WikiDaheim users 2018 (by first revision, by uploader)
This query is marked as a draft
This query has been published
Count the number of edits on WikiDaheim images after upload. This will include edits on own previously uploaded images as well as edits on images of other users.
USE commonswiki_p; SELECT /* SLOW_OK */ DISTINCT actor_name AS user, COUNT(revision.rev_parent_id) as edit_count FROM actor, revision, image, page, categorylinks WHERE page.page_id=categorylinks.cl_from AND actor.actor_id = revision.rev_actor AND image.img_name = page.page_title and revision.rev_page = page.page_id and revision.rev_parent_id > 0 AND categorylinks.cl_to = "Media_from_WikiDaheim_2018_in_Austria/all" GROUP BY user ORDER BY edit_count DESC limit 200;
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in