New ores rollbacker

SQL

USE ruwiki_p;
SELECT actor_name, total, article, file, template, category, portal
FROM (SELECT COUNT(log_id) AS Total,
             SUM(log_namespace = 0) AS article,
             SUM(log_namespace = 6) AS file,
             SUM(log_namespace = 10) AS template,
             SUM(log_namespace = 14) AS category,
             SUM(log_namespace = 100) AS portal,
             log_actor
      FROM logging
      WHERE (log_type = "review") and (log_timestamp > "20190101000000") and (log_action not like "%a")
      GROUP BY log_actor
      ORDER BY total DESC) AS A
INNER JOIN actor
ON A.log_actor = actor.actor_id;
SQL

Checking query status...
