- Quarry

SQL

SELECT 
    a.actor_name, 
    MAX(l.log_timestamp) AS last_action,
    GROUP_CONCAT(DISTINCT g.ug_group SEPARATOR ', ') AS user_groups,
    CASE 
        WHEN g.ug_group = 'global-renamer' THEN 'Global Renamer'
        WHEN g.ug_group = 'steward' THEN 'Steward'
        WHEN g.ug_group = 'bot' THEN 'Bot'
        ELSE 'User'
    END AS role_flag
FROM 
    logging l
JOIN 
    actor a ON l.log_actor = a.actor_id
LEFT JOIN 
    user_groups g ON a.actor_id = g.ug_user
WHERE 
    l.log_type = 'renameuser'
    AND l.log_action = 'renameuser'
GROUP BY 
    a.actor_name
ORDER BY 
    last_action DESC;
SQL

Checking query status...
