SQL
x
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 >= "20220101000000"
group by actor_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.