Revision as of 02:27, 9 September 2007 editMZMcBride (talk | contribs)Extended confirmed users190,597 edits +side-by-side← Previous edit | Latest revision as of 02:51, 3 December 2015 edit undoMZMcBride (talk | contribs)Extended confirmed users190,597 edits updated page | ||
(59 intermediate revisions by 4 users not shown) | |||
Line 1: | Line 1: | ||
<syntaxhighlight lang="sql"> | |||
{| | |||
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'); | |||
| style="vertical-align:top;" | Proposed new code | |||
</syntaxhighlight> | |||
{{User:MZMcBride/Sandbox 3 | |||
|Name = Courtney Love | |||
|Img = CourtneyLove.jpg | |||
<syntaxhighlight lang="sql"> | |||
|Img_capt = Courtney Love in November 2006 | |||
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'); | |||
|Background = solo_singer | |||
</syntaxhighlight> | |||
|Birth_name = Courtney Michelle Harrison | |||
|Alias = Courtney Michelle Love, Courtney Michelle Cobain, Courtney Love Cobain, | |||
# ] | |||
|Born = {{birth date and age|1964|7|9}}<br>], ] | |||
# ] | |||
|Died = | |||
# ] | |||
|Occupation = ], ], ], ], ] | |||
# ] | |||
|Instrument = ], ], ] | |||
# ] | |||
|Genre = ]<br>]<br> | |||
# ] | |||
|Label = ]<br/>]<br/>] / ]<br/>]<br/>]<br/>] | |||
# ] | |||
|Associated_acts = ]<br/>]<br/>]<br/> | |||
# ] | |||
}} | |||
# ] | |||
| style="vertical-align:top;" | Old code | |||
# ] | |||
{{Infobox musical artist | |||
# ] | |||
|Name = Courtney Love | |||
# ] | |||
|Img = CourtneyLove.jpg | |||
# ] | |||
|Img_capt = Courtney Love in November 2006 | |||
# ] | |||
|Background = solo_singer | |||
# ] | |||
|Birth_name = Courtney Michelle Harrison | |||
# ] | |||
|Alias = Courtney Michelle Love, Courtney Michelle Cobain, Courtney Love Cobain, | |||
# ] | |||
|Born = {{birth date and age|1964|7|9}}<br>], ] | |||
# ] | |||
|Died = | |||
# ] | |||
|Occupation = ], ], ], ], ] | |||
# ] | |||
|Instrument = ], ], ] | |||
# ] | |||
|Genre = ]<br>]<br> | |||
# ] | |||
|Label = ]<br/>]<br/>] / ]<br/>]<br/>]<br/>] | |||
# ] | |||
|Associated_acts = ]<br/>]<br/>]<br/> | |||
# ] | |||
}} | |||
# ] | |||
|} | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] | |||
# ] |
Latest revision as of 02:51, 3 December 2015
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');
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