SQL
x
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 >= 20170101000000 group by rev_user order by c desc;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.