Replicas browser and optimizer
This query is marked as a draft
This query has been published
use ruwiki_p; select user_name, count(*) c from revision join user on rev_user=user_id join page on rev_page=page_id where rev_user in (select ug_user from user_groups where ug_group = "bot") and page_namespace = 0 and rev_timestamp >= 20160101000000 and rev_timestamp < 20170101000000 group by rev_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