dewiki.AWWEdits2016

SQL

use dewiki_p;
select 
  (select user_name from user where user_id = rev_user)
, year(rev_timestamp)
, month(rev_timestamp)
, count(*)
from revision 
where  rev_timestamp >20160101000000 and rev_timestamp <20160901000000
and rev_user not in (0,627628)
and rev_page  in (Select page_id from page where page_namespace=4 and page_title like 'Adminwiederwahl/%' and page_id not in (4802555,
4802782,
4802783,
4802784,
4812954,
4819711,
4859347,
4904095,
5793442,
9544986,
9544987,
9544992
)
)
group by 
  rev_user
, year(rev_timestamp)
, month(rev_timestamp)
SQL

Checking query status...
