Active image reviewers who are not in OTRS

SQL

USE commonswiki_p;


SELECT user_name, user_editcount
FROM 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")
  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")
ORDER BY user_editcount DESC;

SQL

Checking query status...