Rename stats - Quarry

SQL

WITH prioritized_groups AS (
    SELECT 
        ug_user,
        ug_group,
        ROW_NUMBER() OVER (
            PARTITION BY ug_user 
            ORDER BY 
                CASE ug_group 
                    WHEN 'steward' THEN 1 
                    WHEN 'global-renamer' THEN 2 
                    WHEN 'bot' THEN 3 
          			WHEN 'wmf-officeit' THEN 4
          			WHEN 'wmf-supportsafety' THEN 5
                    ELSE 6
                END
        ) AS priority
    FROM user_groups
    WHERE ug_group IN ('steward', 'global-renamer', 'bot', 'wmf-officeit', 'wmf-supportsafety')
),
rename_stats AS (
    SELECT 
        COUNT(*) AS rename_count, 
        log_actor, 
        actor_name, 
        actor_user,
        DATE_FORMAT(MAX(log_timestamp), '%b %d %Y %h:%i %p') AS last_action_timestamp
    FROM logging_userindex
    LEFT JOIN actor_logging
    ON logging_userindex.log_actor = actor_logging.actor_id
    WHERE log_type = 'renameuser'
    GROUP BY log_actor, actor_name
    ORDER BY rename_count DESC
)
SELECT 
    rs.rename_count, 
    rs.actor_name, 
    rs.last_action_timestamp, 
    COALESCE(pg.ug_group, '') AS ug_group
FROM rename_stats rs
LEFT JOIN prioritized_groups pg
ON rs.actor_user = pg.ug_user;
SQL

Checking query status...
