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 
                    ELSE 4 
                END
        ) AS priority
    FROM user_groups
    WHERE ug_group IN ('steward', 'global-renamer', 'bot')
),
rename_stats AS (
    SELECT 
        COUNT(*) AS rename_count, 
        log_actor, 
        actor_name, 
        actor_user
    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.log_actor, 
    rs.actor_name, 
    COALESCE(pg.ug_group, 'No Group') AS ug_group
FROM rename_stats rs
LEFT JOIN prioritized_groups pg
ON rs.actor_user = pg.ug_user;
SQL

Checking query status...
