Untitled query #14489

SQL

SELECT
  u.user_name,
  COUNT(CASE WHEN l.log_type = 'abusefilter' AND a.actor_user = u.user_id THEN 1 END) AS abusefilter_count,
  COUNT(CASE WHEN l.log_action = 'block' AND a.actor_user = u.user_id THEN 1 END) AS block_count,
  COUNT(CASE WHEN l.log_action = 'unblock' AND a.actor_user = u.user_id THEN 1 END) AS unblock_count,
  COUNT(CASE WHEN l.log_action = 'reblock' AND a.actor_user = u.user_id THEN 1 END) AS reblock_count,
  COUNT(CASE WHEN l.log_type IN ('contentmodel') AND a.actor_user = u.user_id THEN 1 END) AS contentmodel_count
FROM
  user u
JOIN
  user_groups ug ON u.user_id = ug.ug_user
LEFT JOIN
  logging l ON a.actor_id = l.log_actor
LEFT JOIN
  actor a ON a.actor_id = l.log_actor
WHERE
  ug.ug_group = 'sysop'
GROUP BY
  u.user_name;
SQL

Checking query status...
