Number of all edits in ns0 in certain wiki per year

SQL

use ruwiki_p;
#select * from logging join actor on actor_id=log_actor where log_type not in ("gblblock", "thanks", "massmessage", "spamblacklist", "rights", "newusers", "create", "delete", "protect", "stable", "abusefilter", "block", "merge", "move", "renameuser", "review") and log_timestamp > 20161001000000 and actor_name="Рейму Хакурей" limit 50;
select * from revision join actor on rev_actor=actor_id join page on rev_page=page_id where actor_name="Рейму Хакурей" and page_namespace="6" and rev_timestamp > 20171129000000;

SQL

Checking query status...