Статистика удалений

SQL

USE ruwiki_p;
SELECT actor_name, total, article, file, template, category, userpage, talk
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 = 2) AS userpage,
             SUM(log_namespace%2 = 1) AS talk,
             log_actor
      FROM logging
      WHERE (log_type = "delete") and (log_timestamp > "20190601000000") and (log_action = "delete")
      GROUP BY log_actor
      ORDER BY total DESC) AS A
INNER JOIN actor
ON A.log_actor = actor.actor_id;
SQL

Checking query status...
