Untitled query #85876

SQL

SELECT
    a.actor_name AS 'User',
    COUNT(*) AS 'Number of renamings',
    MAX(log.log_timestamp) AS 'Last action',
    CASE 
        WHEN ug.ug_group IN ('steward', 'global-renamers') THEN ug.ug_group 
        ELSE NULL 
    END AS 'Role'
FROM
    user_groups ug
JOIN
    actor_user a
    ON a.actor_user = ug.ug_user
LEFT JOIN
    logging_userindex log
    ON log.log_actor = a.actor_id
    AND log.log_type = 'gblrename'
GROUP BY
    a.actor_id, a.actor_name, ug.ug_group

UNION ALL

SELECT
    NULL AS actor_id,
    NULL AS actor_name,
    COUNT(*) AS cnt,
    'global-renamer' AS ug_group,
    NULL AS latest_log_timestamp
FROM
    logging_userindex log
JOIN
    user_groups ug
    ON log.log_actor = ug.ug_user
WHERE
    log.log_type = 'gblrename'
SQL

Checking query status...
