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))

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...
