Replicas browser and optimizer
Pages edited by a user from a specific time
This query is marked as a draft
This query has been published
Edits by users for set of high priority pages of a project in date range
use tewiki_p; SELECT page_title as page_title, revactor_actor as User, COUNT(*) as Edits FROM revision INNER JOIN page ON page_id = revision.rev_page INNER JOIN revision_actor_temp ON revactor_page= revision.rev_page WHERE page_namespace=0 GROUP BY revactor_actor ORDER BY Edits DESC LIMIT 100;
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