Ruwiki bot statistics 2020

SQL

# USE ruwiki_p;
# SELECT actor_name, COUNT(*) edits
# FROM revision
# LEFT JOIN page ON rev_page=page_id
# LEFT JOIN actor ON rev_actor=actor_id
# LEFT JOIN user_groups ON actor_user=ug_user
# WHERE ug_group = "bot"
# AND page_namespace = 0
# AND rev_timestamp >= 20200101000000
# AND rev_timestamp < 20210101000000
# GROUP BY actor_user
# ORDER BY edits DESC;

use ruwiki_p;
select actor_name, count(*) c
from revision
join page on rev_page=page_id
join actor 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 >= 20200101000000
and rev_timestamp < 20210101000000
group by actor_user
order by c desc;
SQL

Checking query status...
