Untitled query #85876

SQL

SELECT
    a.actor_name AS User,
    COUNT(log.log_id) AS Number of renamings,
    DATE_FORMAT(MAX(log.log_timestamp), '%b %d %Y %h:%i %p') AS Last action,
    CASE 
        WHEN ug.ug_group IN ('steward', 'global-renamer') THEN ug.ug_group 
        ELSE NULL 
    END AS Role
FROM
    actor_user a
JOIN
    user_groups ug
    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_name, ug.ug_group
HAVING
    COUNT(log.log_id) > 0
ORDER BY
    Number of renamings DESC;
SQL

Checking query status...
