Untitled query #87080

SQL

USE commonswiki_p;
SELECT DISTINCT
 actor_name AS user,
 REPLACE(ug_group, 'sysop', 'admin') AS usergroup,
 CASE WHEN isbot.ug_bot_user IS NOT NULL THEN 'bot' ELSE 'non-bot' END 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 actor.actor_user = lrgroup.ug_user
LEFT JOIN
  (
   SELECT
   ug_user AS ug_bot_user
   FROM user_groups
   WHERE ug_group = "bot"
   ) AS isbot
ON actor.actor_user = isbot.ug_bot_user
WHERE rc_namespace = 6
AND (lrgroup.ug_group = "sysop" OR lrgroup.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...
