Active LR - Quarry

SQL

USE commonswiki_p;
 
SELECT DISTINCT
    actor_name AS user,
    REPLACE(ug_group,'sysop','admin') AS usergroup,
    ug_bot AS bot
FROM recentchanges
INNER JOIN
    (
        SELECT
            ug_user,
            ug_group
        FROM user_groups
        WHERE ug_group = 'sysop'
           OR ug_group = 'Image-reviewer'
    ) AS lrgroup 
ON rc_user = ug_user
LEFT JOIN user_groups AS isbot
ON rc_user = isbot.ug_user AND isbot.ug_group = 'bot'
WHERE rc_namespace = 6 
  AND (ug_group='sysop' OR ug_group='Image-reviewer')
  AND (
        rc_comment LIKE '%icense review%'
        OR rc_comment LIKE '%LR passed%'
        OR rc_comment LIKE '%: passed%'
     )
ORDER BY actor_name ASC;
SQL

Checking query status...
