Active image reviewers who are not in OTRS

SQL

USE commonswiki_p;


SELECT user_name, user_editcount, count(*) as num_reviews_in_RC
FROM user
JOIN recentchanges_userindex ON user_id = rc_user
WHERE user_editcount > 10
  AND user_id IN /* Include local non-bot image reviewers only. */
    (SELECT ug_user
     FROM user_groups
     WHERE ug_group="Image-reviewer" OR ug_group="sysop")
  AND user_id NOT IN
    (SELECT ug_user
     FROM user_groups
     WHERE ug_group="bot")
  AND user_name NOT IN
    (SELECT gu_name
     FROM centralauth_p.globaluser JOIN centralauth_p.localuser ON lu_name=gu_name AND lu_wiki="commonswiki"
     JOIN centralauth_p.global_user_groups ON gug_user=gu_id
     WHERE gug_group="OTRS-member")
  AND rc_comment LIKE "%License review%"
GROUP BY user_id
;
SQL

Checking query status...
