Number of all edits in ns0 in certain wiki per year

SQL

USE ruwiki_p;
SELECT actor_name, log_type, log_action, COUNT(DISTINCT log_title)
  FROM user_groups
 INNER JOIN actor_logging ON actor_user = ug_user
 INNER JOIN logging_userindex ON actor_id = log_actor
 WHERE ug_group IN ('sysop', 'closer')
   AND log_timestamp BETWEEN 20191101000000 AND 20200501000000
   and log_action not like 'move_%'
   and log_action not like '%-a'
   and log_action not like '%-ia'
   and log_type <> "spamblacklist" and log_type <> "thanks" and log_type <> "upload"
GROUP BY log_type, log_action, actor_name

SQL

Checking query status...