Replicas browser and optimizer
This query is marked as a draft
This query has been published
-- Choose the wiki! -- English Wikipedia can take several minutes per day. -- Smaller wikis take a few seconds per day. use thwiki_p; select -- revision_actor_temp will some day be deprecated revision_actor_temp.revactor_actor, count(revision_actor_temp.revactor_actor) as edit_count, actor.actor_name from page, actor, revision, revision_actor_temp where -- Template is 10 -- Module is 828 page.page_namespace = 10 and revision.rev_page = page.page_id and revision.rev_id = revision_actor_temp.revactor_rev and revision_actor_temp.revactor_actor = actor.actor_id and -- Adjust the date revision.rev_timestamp like '2019%' group by revactor_actor order by edit_count desc limit 50;
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