Untitled query #14489

SQL

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

Checking query status...
