Active LR - Quarry

SQL

USE commonswiki_p;
 
SELECT DISTINCT
    actor_name AS user,
    REPLACE(lrgroup.ug_group, 'sysop', 'admin') AS usergroup,
    IF(isbot.ug_user IS NOT NULL, 'bot', 'not a bot') AS bot
FROM recentchanges
JOIN actor
ON recentchanges.rc_actor = actor.actor_id
INNER JOIN
    (
        SELECT
            ug_user,
            ug_group
        FROM user_groups
        WHERE ug_group = 'sysop'
           OR ug_group = 'Image-reviewer'
    ) AS lrgroup 
ON recentchanges.rc_user = lrgroup.ug_user
LEFT JOIN user_groups AS isbot
ON recentchanges.rc_user = isbot.ug_user AND isbot.ug_group = 'bot'
WHERE recentchanges.rc_namespace = 6 
  AND (lrgroup.ug_group = 'sysop' OR lrgroup.ug_group = 'Image-reviewer')
ORDER BY actor.actor_name ASC;
SQL

Checking query status...
