Fork of
Autopatrolled administrators
by Joe Roe
This query is marked as a draft
This query has been published
by Joe Roe.
SQL
AخA
SELECT ug1.ug_user, user_name
FROM user_groups ug1
LEFT JOIN user_groups ug2 ON ug1.ug_user = ug2.ug_user
JOIN user ON user_id = ug1.ug_user
WHERE
ug1.ug_group = "sysop" AND
NOT ug2.ug_group = "autoreviewer"
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.