Untitled query #14489

SQL

WITH Admins AS
  (SELECT user_name,
          user_id
   FROM USER
   JOIN user_groups ON user_id = ug_user
   WHERE ug_group = 'sysop'),
     AdminLogs AS
  (SELECT log_type,
          log_action,
          actor_user
   FROM logging
   JOIN actor ON actor_id = log_actor
   WHERE actor_user IN
       (SELECT admins.user_id
        FROM Admins AS admins)
  		AND log_timestamp >= DATE_FORMAT(CURDATE() - INTERVAL 6 MONTH, '%Y%m%d%H%i%S')
SELECT user_name,
  (SELECT count(*) FROM AdminLogs WHERE log_type = 'abusefilter' AND actor_user = user_id) abusefilter_count,
  (SELECT count(*) FROM AdminLogs WHERE log_type = 'contentmodel' AND actor_user = user_id) contentmodel_count,
  (SELECT count(*) FROM AdminLogs WHERE log_type = 'merge' AND actor_user = user_id) merge_count,
  (SELECT count(*) FROM AdminLogs WHERE log_action = 'block' AND actor_user = user_id) block_count,
  (SELECT count(*) FROM AdminLogs WHERE log_action = 'unblock' AND actor_user = user_id) unblock_count,
  (SELECT count(*) FROM AdminLogs WHERE log_action = 'reblock' AND actor_user = user_id) reblock_count,
  (SELECT count(*) FROM AdminLogs WHERE log_action = 'patrol' AND actor_user = user_id) patrol_count,
  (SELECT count(*) FROM AdminLogs WHERE log_action = 'delete' AND actor_user = user_id) delete_count,
  (SELECT count(*) FROM AdminLogs WHERE log_action = 'restore' AND actor_user = user_id) restore_count,
  (SELECT count(*) FROM AdminLogs WHERE log_action = 'protect' AND actor_user = user_id) protect_count,
  (SELECT count(*) FROM AdminLogs WHERE log_action = 'unprotect' AND actor_user = user_id) unprotect_count
FROM Admins;


#SELECT DISTINCT log_action
#FROM hywiki_p.logging
SQL

Checking query status...
