Fork of
Admins without RfAs
by Pppery
This query is marked as a draft
This query has been published
by Ericliu1912.
SQL
AخA
SELECT user_name
FROM user JOIN user_groups ON ug_user = user_id AND ug_group = "sysop"
WHERE NOT EXISTS (SELECT * FROM page WHERE page_namespace=4 AND page_title=concat("申请成为管理员/", replace(user_name," ","_")))
AND NOT EXISTS (SELECT * FROM user_groups ug2 WHERE ug2.ug_user = user_id AND ug2.ug_group = "bot")
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.