Replicas browser and optimizer
This query is marked as a draft
This query has been published
select actor_name, count(*) c from revision_userindex join page on rev_page=page_id join actor_revision on rev_actor=actor_id where actor_user in (select ug_user from user_groups where ug_group = "bot") and page_namespace = 0 and rev_timestamp >= "20210101000000" and rev_timestamp < "20220101000000" group by actor_user order by c desc;
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