Replicas browser and optimizer
WikiDaheim correctors 2019 (after first revision)
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, /*user_groups,*/ revision, revision as revision0, 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 revision0.rev_parent_id = 0 and revision.rev_page = revision0.rev_page and revision.rev_actor != revision0.rev_actor /*and user_groups.ug_user = actor.actor_id and user_groups.ug_group != 'bot'*/ AND categorylinks.cl_to = "Media_from_WikiDaheim_2019_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