current admins who held autopatrol before ~2011

Fork of current admins who held autopatrol before ~2011 by AntiCompositeNumber

This query is marked as a draft This query has been published by NguoiDungKhongDinhDanh.

SQL

SELECT user_name
FROM user
JOIN user_groups sysop ON sysop.ug_user = user_id
JOIN user_former_groups ON ufg_user = user_id
LEFT JOIN user_groups ap ON ap.ug_user = user_id AND ap.ug_group = "autoreviewer"
WHERE 
	sysop.ug_group = "sysop"
    AND ufg_group = "autoreviewer"
    AND ap.ug_group IS NULL

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...