Тт - Quarry

SQL

use ttwiki_p;
#select user_name, count(*) c from revision join user on rev_user=user_id join page on rev_page=page_id where page_namespace = 0 and rev_timestamp >= 20150101000000 and rev_timestamp < 20160101000000 group by rev_user order by c desc limit 10;
select count(*) c from revision join page on rev_page=page_id join user on rev_user=user_id where page_namespace = 0 and rev_user in (select ug_user from user_groups where ug_group = "bot") and rev_timestamp >= 20160101000000 and rev_timestamp < 20170101000000;
SQL

Checking query status...
