User:MZMcBride/Sandbox 5: Difference between revisions

< User:MZMcBride Browse history interactively ← Previous editContent deleted Content addedVisual WikitextInline

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');