select distinct page_title from page join categorylinks on cl_from = page_id where cl_to = 'Wikipedia_bureaucrats' and page_namespace in (2,3) and substring_index(replace(page_title, '_', ' '), '/', 1) not in (select user_name from user join user_groups on ug_user = user_id where ug_group = 'bureaucrat');
[no results]
select distinct page_title from page join categorylinks on cl_from = page_id where cl_to = 'Wikipedia_administrators' and page_namespace in (2,3) and substring_index(replace(page_title, '_', ' '), '/', 1) not in (select user_name from user join user_groups on ug_user = user_id where ug_group = 'sysop');
- User:Daveydweeb
- User:Slumgum
- User:Tra
- User:Amalas
- User:LAX
- User:Melesse
- User:UberScienceNerd
- User:Vaoverland/Administrator_role
- User:Stephen_Bain
- User:Vaoverland/aboutme
- User:Le_Faux_Nez_de_L'Aquatique
- User:L'Aquatique
- User:Hmwith
- User:Fainites
- User:Magister_Mathematicae
- User:EyeSerene
- User:Climie.ca
- User:JWSchmidt
- User:Jtdirl
- User:Davidgothberg
- User:Sam_Vimes
- User:Tkinias
- User:CJLL_Wright
- User:Jj137
- User:Hu12
- User:Hamster_Sandwich
- User:RyanGerbil10
- User:DO11.10
- User:Mtmelendez
- User:Bryan_Derksen
- User:David_Newton
- User:Pablo-flores
- User:FisherQueen
- User:Mysekurity
- User:Kakofonous
- User:Danger
- User:Henrik
- User:Jredmond
- User:Qaz
- User:Ronline
- User:Dsmdgold
- User:Shanel
- User:Hit_bull,_win_steak
- User:BirgitteSB
- User:Seb26
- User:Kilo-Lima
- User:Leebo
- User:Diberri
- User:Kbthompson
- User:Stevenfruitsmaak
- User:Canderson7
- User:Qwghlm
- User:ClockworkSoul
- User:Wifione/userboxes
- User:Wifione/userbox1
- User:Shell_Kinney/Infobox
- User:Dieter_Simon
- User:Wagino_20100516
- User:Tlranln999
- User:Paxse
- User:Jimsjohnson
- User:Hrengifo
- User:Kristtty
- User:Arjun01
- User:Nad808080
- User:Kristoffer_L
- User:Joseph_the_writer
- User:PatSunter
- User:VancityEditor
- User:Ramon_Serra
- User:MikeLynch
- User:Alliver
- User:Tcvella
- User:SausageParty77934
- User:TranslatorUK
- User:Junirullah/sandbox
- User:Prof.junirullah/sandbox
- User:Dry_Martini
- User:Oskar_Sigvardsson/List_of_administrators
- User:Jamlaw223
- User:Max7310
- User:Sonulangaya
- User:Reigndeleon
- User:Elen_of_the_Roads
- User:Pat.moloney
- User:Rocking_ramlal
- User:Vivekprakash92
- User:Gmaxwell/adminship_map
- User:Stewartadcock
- User:Kaiger
- User:TheElderFox
- User:Ronald7488
- User:Sivaraam07
- User:RaysRates
- User:Xbowery
- User:ChriCom
- User:Tropicalpurplekitty
- User:Sobek121
- User:Mel_Etitis/sandbox
- User:Loreanar
- User:Phiraphon
- User:Jiale8331
- User:Hyipworld
- User:Betsy6286
- User:Admiral_Alvin
- User:ERcheck
- User:Billyoweston
- User:Bagumbe