User:MZMcBride/Sandbox 8: Difference between revisions

< User:MZMcBride Browse history interactively ← Previous edit Next edit →Content deleted Content addedVisual WikitextInline

Revision as of 21:11, 29 December 2009 editMZMcBride (talk \| contribs)Extended confirmed users190,601 edits +list← Previous edit		Revision as of 01:31, 30 December 2009 edit undoMZMcBride (talk \| contribs)Extended confirmed users190,601 edits +listNext edit →
Line 1:		Line 1:
			{\| class="wikitable sortable plainlinks" style="width:100%; margin:auto;"
	<source lang="sql">
			\|- style="white-space:nowrap;"
	SELECT
			! No.
	page_title,
			! File
	rev_user_text,
			\|-
	rev_timestamp
			\| 1
	FROM page
			\| ]
	JOIN revision
			\|-
	ON rev_page = page_id
			\| 2
	JOIN (SELECT
			\| ]
	pl_title
			\|-
	FROM page
			\| 3
	JOIN pagelinks
			\| ]
	ON pl_from = page_id
			\|-
	WHERE page_namespace = 2
			\| 4
	AND page_title = 'MZMcBride/Sandbox_8'
			\| ]
	AND pl_namespace = 3) AS pltmp
			\|-
	ON pltmp.pl_title = page_title
			\| 5
	AND page_namespace = 3
			\| ]
	WHERE rev_timestamp = (SELECT
			\|-
	MAX(rev_timestamp)
			\| 6
	FROM revision AS last
			\| ]
	WHERE last.rev_page = page_id);
			\|-
	</source>
			\| 7
	<pre>
			\| ]
	page_title rev_user_text rev_timestamp
			\|-
	$yD! Avraham 20091222022323
			\| 8
	-Majestic- Nehrams2020 20091110035147
			\| ]
	.:Alex:. MiszaBot III 20091029123541
			\|-
	88wolfmaster Simply south 20091113155200
			\| 9
	A_Man_In_Black Erwin85Bot 20091130010627
			\| ]
	AcesUpMaSleeve Burner0718 20091212040153
			\|-
	Adammw Skier Dude 20091226052652
			\| 10
	Admeister200x Skier Dude 20091212070009
			\| ]
	Admiral_Norton MiszaBot III 20091226124330
			\|-
	Ajkr925 Xenobot 20090924031723
			\| 11
	Akbeancounter Xenobot 20090924031732
			\| ]
	Akino005 Xenobot 20090924031740
			\|-
	Alby13 Aspects 20091109184729
			\| 12
	AlexanderTG Xenobot 20090924031756
			\| ]
	Alexbuirds Xenobot 20090924031804
			\|-
	Ambrosia- Garion96 20091017124812
			\| 13
	Andrew.in.snow Xenobot 20090924031836
			\| ]
	Andrewrox424 Xenobot 20090924031844
			\|-
	Andrzejbanas Hunter Kahn 20091228033022
			\| 14
	Angel,Isaac Xenobot 20090924031929
			\| ]
	Armando12 ZooFari 20091107015112
			\|-
	Atallcostsky Xenobot 20090924032012
			\| 15
	Avae01 Xenobot 20090924032013
			\| ]
	Avs_dps Treelo 20091205182139
			\|-
	Ayrton_Prost Cs-wolves 20091207235949
			\| 16
	BIONICLE233 Delicious carbuncle 20091130170236
			\| ]
	Bagel7 Xenobot 20090924032048
			\|-
	Bakabaka Xenobot 20090924032050
			\| 17
	BaldMonkey Xenobot 20090924032052
			\| ]
	Benseac Xenobot 20090924032058
			\|-
	Berenlazarus Xenobot 20090924032101
			\| 18
	Bernie_bernbaum Xenobot 20090924032104
			\| ]
	Berserker79 Xenobot 20090924032107
			\|-
	BetaTesterDLA Xenobot 20090924032109
			\| 19
	BigHairRef Phantomsteve 20091218090721
			\| ]
	Bill Bill 20091122023226
			\|-
	Billy_Bishop Xenobot 20090924032117
			\| 20
	Blackhawk_charlie2003 Xenobot 20090924032123
			\| ]
	Bloodholds Xenobot 20091007040858
			\|-
	BlueCaper Skier Dude 20091213054730
			\| 21
	Brendankm EdwardsBot 20091223023839
			\| ]
	Brooza Xenobot 20090924032202
			\|-
	Bud0011 Xenobot 20091007040926
			\| 22
	Bungle Bungle 20091125093106
			\| ]
	CFLeon Xenobot 20090924032220
			\|-
	CJS102793 Xenobot 20090924032241
			\| 23
	CP\\M BrownBot 20091221033719
			\| ]
	CalcbikeUSBPriapPs2 Xenobot 20090924032210
			\|-
	CaptainVindaloo Erwin85Bot 20091111010807
			\| 24
	Caramelldansener Xenobot 20090924032216
			\| ]
	Chan_Yin_Keen Xenobot 20090924032224
			\|-
	Chanlord Xenobot 20090924032228
			\| 25
	Chipotlehero Xenobot 20090924032233
			\| ]
	CiaranG Dylanfromthenorth 20091226221813
			\|-
	ClaudeLv250 Xenobot 20090924032244
			\| 26
	Clone2727 Xenobot 20090924032245
			\| ]
	ClonedPickle Skier Dude 20091208071622
			\|-
	Cloud668 Xenobot 20091007041004
			\| 27
	Clyde_Miller Xenobot 20090924032253
			\| ]
	Cocoaguy Brambleclawx 20091229002751
			\|-
	ConstantineChernabog Marcus Brute 20091129002841
			\| 28
	Contributor777 Nehrams2020 20091201061139
			\| ]
	CoolingGibbon SkyWalker 20091224141316
			\|-
	Cpuwhiz11 Xenobot 20090924032352
			\| 29
	Cryptod Xenobot 20091007041056
			\| ]
	Cunners Xenobot 20090924032358
			\|-
	CyberSkull Skier Dude 20091226045438
			\| 30
	DBBell Xenobot 20090924032436
			\| ]
	DBased Yobot 20091205193438
			\|-
	DJS24 Xenobot 20090924032501
			\| 31
	Dacheatcode Xenobot 20090924032414
			\| ]
	Damërung IMatthew 20091226141642
			\|-
	Daniel_Christensen Daniel Christensen 20091219083020
			\| 32
	Danorux Xenobot 20090924032430
			\| ]
	Dappl Xenobot 20090924032432
			\|-
	Deadkid_dk Deadkid dk 20091229015632
			\| 33
	Deathtrap3000 Xenobot 20090924032443
			\| ]
	Deblopper Falcon9x5 20091206220653
			\|-
	Deckiller New Age Retro Hippie 20091220115849
			\| 34
	Delta759 Xenobot 20090924032454
			\| ]
	Denjo ZooFari 20091107043813
			\|-
	Doktor_Wilhelm Xenobot 20090924032504
			\| 35
	DonEd Alankc 20091116041059
			\| ]
	Dooly00000 The Man in Question 20091203232419
			\|-
	Douglasr007 Gadget850 20091130161236
			\| 36
	Drahcir EdwardsBot 20091223025057
			\| ]
	DubaiTerminator Salavat 20091216163640
			\|-
	Duffaboy Xenobot 20090924032545
			\| 37
	DurinsBane87 Xenobot 20090924032548
			\| ]
	Dusk_Knight Xenobot 20090924032550
			\|-
	Dylanlip Treelo 20091205181520
			\| 38
	EVula EVula 20091229165557
			\| ]
	Eivind 84.48.34.120 20090925193820
			\|-
	Elenseel Skier Dude 20091214031358
			\| 39
	Elven6 Magioladitis 20091215204759
			\| ]
	Emperor_Gestahl Xenobot 20090924032619
			\|-
	Enzomartinelli Kleinzach 20091227074837
			\| 40
	Eruhildo Xenobot 20090924032631
			\| ]
	Estarrol Estarrol 20091014024014
			\|-
	Fairfieldfencer A Nobody 20091224200443
			\| 41
	Fall_Of_Darkness Xenobot 20090924032704
			\| ]
	FangzofBlood Xenobot 20090924032708
			\|-
	Farslayer Xenobot 20090924032710
			\| 42
	FastKarts Xenobot 20090924032713
			\| ]
	FastLizard4 MiszaBot III 20091225140214
			\|-
	Fiveinacan Xenobot 20090924032719
			\| 43
	Fredil_Yupigo Xenobot 20090924032730
			\| ]
	Frodet Skier Dude 20091213002003
			\|-
	G859 Xenobot 20090924032743
			\| 44
	GENERALZERO Fox816 20091221045713
			\| ]
	GILLY1089 Xenobot 20090924032834
			\|-
	GTA_Ganxtaize Xenobot 20090924032929
			\| 45
	Galactor213 Xenobot 20090924032745
			\| ]
	Gamer007 Xenobot 20090924032749
			\|-
	Gaogier Secret Saturdays 20091208030221
			\| 46
	Giggy MiszaBot III 20091215141241
			\| ]
	Gilagod101 MiszaBot 20091220232204
			\|-
	Govvy Trhoult 20091223162417
			\| 47
	Green451 Xenobot 20090924032852
			\| ]
	Greeves Xenobot 20091007041345
			\|-
	Greg_Tyler EdwardsBot 20091223025843
			\| 48
	Grlshvekooties7 Xenobot 20090924032921
			\| ]
	Guardaviewer Xenobot 20090924032931
			\|-
	Haha169 Thegreyanomaly 20091016194919
			\| 49
	Hello32020 MiszaBot III 20091228142206
			\| ]
	Herald_Alberich Xenobot 20090924033003
			\|-
	HertzaHaeon Xenobot 20090924033006
			\|}
	Hewinsj Xenobot 20090924033008
	Hisak Xenobot 20090924033011
	Holek Xenobot 20090924033015
	Huwmanbeing Omnedon 20091219182617
	Icemotoboy Skier Dude 20091213062902
	J.delanoy TreasuryTag 20091229185101
	JR98664 SchuminWeb 20091220173549
	J_happy XxReikoxX 20090930214846
	JaidynM Xenobot 20090924033054
	Jake200493 Morbidthoughts 20091103190657
	Jalalafzal SineBot 20091018031026
	Jambeeno Xenobot 20090924033100
	James_xeno Xenobot 20090924033102
	Janalynn99 Xenobot 20090924033104
	Jas315 Xenobot 20090924033106
	JavaTenor Xenobot 20090924033109
	Jerjer Xenobot 20090924033117
	Jetman123 Xenobot 20090924033118
	JimmyBlackwing FullMetal Falcon 20091217033711
	Jj984jj Xenobot 20090924033133
	Jmcollier Xenobot 20090924033135
	Jo3y Xenobot 20090924033137
	John.n-irl Skier Dude 20091213022154
	Johnnyfog Skier Dude 20091210081042
	Jon_Holly BrownBot 20091221185208
	Jon_swe Guyinblack25 20091123185828
	JovBlackheart Xenobot 20090924033154
	Jp07 Mcorazao 20091223162151
	Jump_Guru Jump Guru 20091013205728
	Jwoodger SuggestBot 20091218043014
	K1Bond007 Hairy Dude 20090930164103
	Kacex Xenobot 20090924033214
	Kamahl Xenobot 20090924033218
	Kamuixtv Xenobot 20090924033221
	Kanogul Xenobot 20091007041524
	Kausill JCbot 20091216043929
	KdogDS Xenobot 20090924033232
	Kelaidis Xenobot 20090924033237
	KernelExcqtable Xenobot 20090924033239
	Kerotan EdwardsBot 20091223031022
	KevinKung Xenobot 20090924033247
	KingPenguin Skier Dude 20091212064336
	King_Gemini MiszaBot 20091220235050
	Kingoomieiii EdwardsBot 20091223031102
	Klingoncowboy4 JaGa 20091211052725
	Kliu1 Xenobot 20090924033357
	KojiDude A Nobody 20091224170458
	KojieroSaske Xenobot 20090924033405
	Kornfan71 EdwardsBot 20091223031131
	Kubaru Xenobot 20090924033415
	LaughingReaper LaughingReaper 20091205060058
	Lego3400 Gazimoff 20091018123947
	Letter_7 GroundZ3R0 002 20091222055103
	Linuxbeak Brian0918 20090902173741
	Littleghostboo Alainr345 20091024075930
	Llamapalooza87 Xenobot 20090924033448
	Loic54 Xenobot 20090924033454
	Loolylolly1997 Treelo 20091205181849
	Lukipuk Skier Dude 20091213022503
	Luksuh BrownBot 20091221190708
	MLauba MiszaBot III 20091229151218
	MOOOOOPS MOOOOOPS 20091118054730
	MRacer ENewsBot 20091201025427
	Machete97 Xenobot 20090924033516
	Maintainerzero Xenobot 20090924033518
	Master_Bigode MiszaBot III 20091223152249
	Mattthemutt Crusio 20091215155335
	MaulYoda Xenobot 20090924033559
	Maverick_Leonhart Xenobot 20090924033601
	Megaman_en_m 98.71.212.75 20091105220802
	Melodia Jonyungk 20091227011532
	Mendaliv MiszaBot III 20091223152721
	Merkurix Xenobot 20090924033615
	Merlinsorca A8UDI 20091129015828
	Michael_IX_the_White Anothroskon 20091121170029
	Michaelrccurtis Xenobot 20090924033626
	Mick_96 Xenobot 20090924033628
	Mikethegreen Xenobot 20090924033632
	Mizunoyojimbo Xenobot 20091007041743
	Mnemnoch Xenobot 20090924033648
	Moogle_12 Xenobot 20090924033651
	Mouse_Nightshirt Xenobot 20090924033657
	Mr.NorCal55 BrownBot 20091221193558
	Mr._Lefty EdwardsBot 20091223032057
	Mr._Sinistar Xenobot 20090924033703
	Mr._XYZ Skier Dude 20091210074117
	MrAngy Xenobot 20090924033727
	Mushroom Mushroom 20091216120618
	Mynameisnotpj Erwin85Bot 20091031011526
	Nahallac_Silverwinds MiszaBot 20091221001634
	Nanten Xenobot 20090924033816
	Natcong Xenobot 20091007041828
	Nblschool Nehrams2020 20091201061258
	Nburden Nburden 20091217190627
	Ned_Scott Ned Scott 20091225060150
	NeonMerlin EdwardsBot 20091223032233
	NerfGUNNER06 Xenobot 20091007041833
	NessLord64 Xenobot 20090924033845
	Neutralle Xenobot 20090924033847
	New_Order Xenobot 20090924033849
	New_User Thesavagenorwegian 20091015161052
	Next-Genn-Gamer IBen 20091224002812
	Nextil Xenobot 20090924033857
	Nick_R Guyinblack25 20091001171748
	Ninja_Wizard Xenobot 20091007041848
	Noctrine Xenobot 20090924033915
	Noj_r BrownBot 20091221192445
	Nreive MiszaBot III 20091206153720
	Nutiketaiel Nutiketaiel 20091229133038
	O MiszaBot III 20091223154935
	Octurion Xenobot 20091007041916
	OgiBear Xenobot 20090924033933
	Omnechist Xenobot 20091007041733
	Only1true Xenobot 20090924033938
	OtakuMan XLinkBot 20091211045000
	Paaerduag Erwin85Bot 20091123010459
	PandaSaver Xenobot 20090924033951
	Paper_Luigi Skier Dude 20091213050456
	Pejorative.majeure Nutiketaiel 20091106185258
	Penale52 Peripitus 20091222225119
	Permethius EdwardsBot 20091223032747
	Person373 Xenobot 20090924034025
	Phorque NJR ZA 20091113072957
	Piecemealcranky ZooFari 20091118025100
	Pineapple_fez ZooFari 20091127152945
	Plasma_Twa_2 BorgQueen 20091228161458
	Pmlineditor Airplaneman 20091228041524
	Praetor_alpha Xenobot 20090924034056
	Promethean 98.248.33.198 20091229093558
	Pupster21 EdwardsBot 20091223032945
	QuasiAbstract MiszaBot III 20090924155953
	Quatreryukami Xenobot 20090924034129
	QueenCake Eastmain 20091028020541
	Quickmythril Skier Dude 20091208060707
	Rafichamp Xenobot 20090924034136
	Ravenshawprime Xenobot 20090924034138
	Realrachel Xenobot 20090924034144
	RebirthThom MiszaBot 20091221003901
	Red_Phoenix MiszaBot III 20091007161800
	Red_walnut Xenobot 20090924034207
	Resplendent ZooFari 20091109003312
	Rikken664 Xenobot 20090924034210
	Riotrocket8676 MiszaBot III 20091222160915
	Roar888 Xenobot 20091007042104
	Rodzilla Xenobot 20090924034228
	Roninbk MiszaBot 20091220135014
	Rwiggum Peripitus 20091219053535
	S.C.Ruffeyfan Treelo 20091205181748
	SLJCOAAATR_1 Xenobot 20090924034426
	SYSS_Mouse Tenmei 20091126011931
	S_Luke Nehrams2020 20091110042222
	Sahmeditor Mkdw 20091128115339
	Saimdusan Saimdusan 20091031002641
	SamuraiFez Xenobot 20090924034251
	Scottie_theNerd Xenobot 20090924034256
	Sdegner Backtable 20091010034458
	Sdornan Xenobot 20090924034316
	Seareever Xenobot 20090924034320
	SeigeTank2000 Xenobot 20090924034323
	Senshi Xenobot 20090924034325
	Sephiroth_BCR Kungming2 20091227124911
	Sethimothy Xenobot 20090924034335
	Sfxprefects Ophois 20091228040909
	SharkD A Nobody 20091224181507
	Shawnc Axl 20091009215210
	Shrumster Bibliomaniac15 20091128001523
	Silentaria Nehrams2020 20091110042325
	Silver_Sonic_Shadow SineBot 20091211050339
	Simianwolverine Xenobot 20090924034404
	Sir_Intellegence MiszaBot III 20091025161545
	Sis_and_bro RadioFan 20091018200521
	Slordak Slordak 20091218161900
	Smurdah ClueBot III 20091010043635
	Snailwalker Xenobot 20090924034433
	Sotomura Xenobot 20090924034442
	SpartanGreg09 Josiah Rowe 20091202213835
	SpringWig Xenobot 20090924034444
	Sprite7868 Nehrams2020 20091110042407
	Spug Xenobot 20090924034448
	Staka Staka 20091206004108
	StarBP Xenobot 20090924034458
	Stezton Stezton 20091222161921
	Streetsabre Xenobot 20090924034508
	Strongsauce Xenobot 20091007042352
	SunDragon34 ClueBot III 20091205185253
	SuperSonicUnleashed Skier Dude 20091214030720
	Super_Knuckles Xenobot 20090924034524
	Superstooge Xenobot 20090924034528
	Surachit Zscout370 20091223090502
	Swampfire MiszaBot 20091221005929
	Syrthiss Syrthiss 20091217184802
	TKD EdwardsBot 20091223034612
	TaerkastUA ClueBot III 20091226221105
	Taifarious1 EdwardsBot 20091223034632
	Tanankyo Xenobot 20090924034643
	Teabonesix Xenobot 20090924034648
	Tes753 Xenobot 20090924034708
	Tgfcoder Xenobot 20090924034713
	TheDarkCrusader Xenobot 20090924034747
	The_$R$ MiszaBot 20091221010147
	The_Beatles_Fan Xenobot 20090924034725
	The_Cake_is_a_Lie Black Kite 20091107121148
	The_Dark_Side Ramon4 20091106170015
	The_Fwanksta Xenobot 20091007042441
	The_Helper_S Xenobot 20090924034742
	The_Ronin Xenobot 20090924034744
	The_Zig Xenobot 20090924034746
	Thedeadmanandphenom MiszaBot 20091221010616
	Themcman1 EdwardsBot 20091223034920
	Theseven7 Xenobot 20090924034841
	Thingg SchfiftyThree 20091224030202
	Thirtysilver Xenobot 20090924034851
	Thisispain Xenobot 20090924034853
	Thunderforge Fastily 20091221011612
	Thuringowacityrep Ozdaren 20091103214240
	TigerK_69 Skier Dude 20091212064552
	Totalinarian 03md 20091130140206
	Trachtemacht Skier Dude 20091213062346
	Treyvo Xenobot 20091007042544
	Triradiates Xenobot 20090924034923
	Trulystand700 BrownBot 20091221200449
	Tylerp9p Gadget850 20091130170503
	UnfriendlyFire Xenobot 20090924034948
	Unknown_the_Hedgehog Xenobot 20090924034958
	Unknownlight Xenobot 20090924034959
	UrbenLegend Xenobot 20090924035003
	Urrgh5591 ZooFari 20091107030425
	UzEE ClueBot III 20091224061022
	VMAAXT Xenobot 20090924035031
	Vanderdecken Skier Dude 20091226045428
	VatooVatoo Xenobot 20090924035022
	Vinsfan368 Cunard 20091228095636
	Vitruelugia Xenobot 20090924035027
	Vitz-RS 7107delicious 20091103143815
	Weeliljimmy Xenobot 20090924035036
	Weeman_com Xenobot 20090924035038
	White_bishop Xenobot 20090924035044
	Wikipedian06 SlimVirgin 20091102191136
	WikipedianMarlith BrownBot 20091221191006
	Wirbelwind Xenobot 20090924035105
	Woad85 Skier Dude 20091208044816
	Wonx2150 BrownBot 20091221201438
	Wowowwiki Xenobot 20090924035112
	Xangel Xenobot 20090924035237
	Xeccos Xenobot 20090924035238
	Xero_Anarian Xenobot 20090924035244
	Xtreme_racer ZooFari 20091118025207
	Yzmo MiszaBot III 20091223173446
	ZFGokuSSJ1 Xenobot 20090924035301
	Zilog_Jones Xenobot 20090924035306
	</pre>

Revision as of 01:31, 30 December 2009

No.	File
1	File:"Das_neue_Rudolf-Harbig-Stadion"..._book.jpg
2	File:"Stadium_Dresden"_logo.jpg
3	File:'aint_misbehavin'.jpg
4	File:-Ultimate-Wolverine-VS-Hulk-.jpg
5	File:0-7679-1676-X.jpg
6	File:0.25_EGP_obverse.jpg
7	File:001_Charles_I_as_painted_by_Sir_Anthony_van_Dyck_and_portrayed_by_Sir_Alec_Guiness.jpg
8	File:002_Olivier_Cromwell_as_painted_warts_and_all_by_Peter_Lely_aka_Pieter_van_der_Faes_and_portrayed_by_Richard_Harris.jpg
9	File:003_Sir_Edward_Hyde_later_1st_Earl_of_Clarendon_in_a_print_of_the_time_and_portrayed_by_Nigel_Stock.jpg
10	File:004_Sir_Thomas_Fairfax_in_a_print_of_the_time_and_portrayed_by_Douglas_Wilmer.jpg
11	File:007FRWLvg2.jpg
12	File:007Scaramanga.jpg
13	File:01_-_hell_march_2.ogg
14	File:01_Hell_March.ogg
15	File:0203_Gaia_Gear_novel.jpg
16	File:02_In_your_hands-01.ogg
17	File:031907frontpage400.gif
18	File:036267-fc12.jpg
19	File:03_Dusk_Hour.ogg
20	File:03_The_Girl_Is_Mine.ogg
21	File:06_-_act_on_instinct.ogg
22	File:08S-MG-Logo_STKD-www_color.jpg
23	File:08_Digimon_X-Evolution.jpg
24	File:09RC_AWARD_LOGO_WB-4-.JPG
25	File:1.1_-_The_Nightmare_Fair.jpg
26	File:10-2008-a.jpg
27	File:10-2008-b.jpg
28	File:10-7-2005_News_Page.jpg
29	File:10-8.jpg
30	File:100-Baht_Banknote_Series_14_Back.jpg
31	File:10000_denari,_1992-_lice.jpg
32	File:10000_denari,_1992-_pozadina.jpg
33	File:10000pt.jpg
34	File:10000t.jpg
35	File:1000_denari,_1992-_lice.jpg
36	File:1000_denari,_1992-_pozadina.jpg
37	File:1000_denari,_1996-_lice.jpg
38	File:1000_denari,_1996-_pozadina.jpg
39	File:1000_denari,_2003-_lice.jpg
40	File:1000_denari,_2003-_pozadina.jpg
41	File:1000wordscover.jpg
42	File:100_denari,_1992-_lice.jpg
43	File:100_denari,_1992-_pozadina.jpg
44	File:100_denari,_1993-_lice.jpg
45	File:100_denari,_1993-_pozadina.jpg
46	File:100_denari,_1996-_lice.jpg
47	File:100_denari,_1996-_pozadina.jpg
48	File:100dram-old.jpg
49	File:100skk.jpg