2009 Topps Allen & Ginter World's Champions - Revision history

Stalegum: /* Rip Cards */

2021-08-12T17:48:37Z

Rip Cards

← Older revision		Revision as of 13:48, 12 August 2021
Line 265:		Line 265:

	===Rip Cards===		===Rip Cards===

			https://img.comc.com/i/Baseball/2009/Topps-Allen--Ginters---Rip-Cards---Ripped/RC82/Carl-Crawford.jpg?id=9a91c69c-8832-4948-bbb3-08e1e20c12f2&size=original&side=front&.jpg
			https://img.comc.com/i/Baseball/2009/Topps-Allen--Ginters---Rip-Cards---Ripped/RC82/Carl-Crawford.jpg?id=9a91c69c-8832-4948-bbb3-08e1e20c12f2&size=original&side=back&.jpg

	Each Rip Card is serial-numbered to the production figures listed below and has a smaller card (either a Mini Exclusive card or Red Ink autograph) embedded inside.		Each Rip Card is serial-numbered to the production figures listed below and has a smaller card (either a Mini Exclusive card or Red Ink autograph) embedded inside.

2019-07-13T12:58:54Z

Rip Cards

← Older revision		Revision as of 08:58, 13 July 2019
Line 270:		Line 270:
	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num,player,serial FROM cards WHERE (year = 2009) AND (setname = 'Topps Allen and Ginter''s Rip Card')		SELECT num,player,serial FROM cards WHERE (year = 2009) AND (setname = 'Topps Allen and Ginter''s Rip Card')
	~~ORDER BY~~ num ~~+0 ASC~~;		order by cast(substr(num,3) as unsigned) asc;
	</sql2wiki>		</sql2wiki>

2019-07-13T12:58:34Z

Dick Perez Original Sketches

← Older revision		Revision as of 08:58, 13 July 2019
Line 261:		Line 261:
	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num, player FROM cards WHERE (year = 2009) AND (setname = "Topps Allen and Ginter's Dick Perez Original Sketches")		SELECT num, player FROM cards WHERE (year = 2009) AND (setname = "Topps Allen and Ginter's Dick Perez Original Sketches")
	~~ORDER BY~~ num ~~+0 ASC~~;		order by cast(substr(num,3) as unsigned) asc;
	</sql2wiki>		</sql2wiki>

	===Rip Cards===		===Rip Cards===

2019-07-13T12:58:15Z

Cabinets

← Older revision		Revision as of 08:58, 13 July 2019
Line 252:		Line 252:
	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num, player FROM cards WHERE (year = 2009) AND (setname = "Topps Allen and Ginter's Cabinets")		SELECT num, player FROM cards WHERE (year = 2009) AND (setname = "Topps Allen and Ginter's Cabinets")
	~~ORDER BY~~ num ~~+0 ASC~~;		order by cast(substr(num,3) as unsigned) asc;
	</sql2wiki>		</sql2wiki>

	===Dick Perez Original Sketches===		===Dick Perez Original Sketches===

2019-07-13T12:54:52Z

Mini World's Biggest Hoaxes, Hoodwinks and Bamboozles

← Older revision		Revision as of 08:54, 13 July 2019
Line 229:		Line 229:
	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num, player FROM cards WHERE (year = 2009) AND (setname = "Topps Allen and Ginter's Mini Hoaxes")		SELECT num, player FROM cards WHERE (year = 2009) AND (setname = "Topps Allen and Ginter's Mini Hoaxes")
	ORDER BY cast(substr(num,3) as unsigned) asc;		ORDER BY cast(substr(num,4) as unsigned) asc;
	</sql2wiki>		</sql2wiki>

2019-07-13T12:54:29Z

Mini World's Biggest Hoaxes, Hoodwinks and Bamboozles

← Older revision		Revision as of 08:54, 13 July 2019
Line 229:		Line 229:
	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num, player FROM cards WHERE (year = 2009) AND (setname = "Topps Allen and Ginter's Mini Hoaxes")		SELECT num, player FROM cards WHERE (year = 2009) AND (setname = "Topps Allen and Ginter's Mini Hoaxes")
	ORDER BY num ~~ASC~~;		ORDER BY cast(substr(num,3) as unsigned) asc;
	</sql2wiki>		</sql2wiki>

	===N-43===		===N-43===

2019-07-13T12:53:26Z

Mini National Heroes

← Older revision		Revision as of 08:53, 13 July 2019
Line 217:		Line 217:
	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num,player FROM cards WHERE (year = 2009) AND (setname = "Topps Allen and Ginter's Mini National Heroes")		SELECT num,player FROM cards WHERE (year = 2009) AND (setname = "Topps Allen and Ginter's Mini National Heroes")
	ORDER BY num ~~+0 ASC~~;		ORDER BY cast(substr(num,3) as unsigned) asc;
	</sql2wiki>		</sql2wiki>

2019-07-13T12:53:10Z

Mini Extinct Animals

← Older revision		Revision as of 08:53, 13 July 2019
Line 207:		Line 207:
	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num, player FROM cards WHERE (year = 2009) AND (setname = "Topps Allen and Ginter's Mini Extinct Creatures")		SELECT num, player FROM cards WHERE (year = 2009) AND (setname = "Topps Allen and Ginter's Mini Extinct Creatures")
	ORDER BY num ~~+0 ASC~~;		ORDER BY cast(substr(num,3) as unsigned) asc;
	</sql2wiki>		</sql2wiki>

	===Mini National Heroes===		===Mini National Heroes===

2019-07-13T12:52:01Z

Mini Inventions of the Future

← Older revision		Revision as of 08:52, 13 July 2019
Line 197:		Line 197:
	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num, player FROM cards WHERE (year = 2009) AND (setname = "Topps Allen and Ginter's Mini Inventions of the Future")		SELECT num, player FROM cards WHERE (year = 2009) AND (setname = "Topps Allen and Ginter's Mini Inventions of the Future")
	ORDER BY num +0 asc;		ORDER BY cast(substr(num,3) as unsigned) asc;
	</sql2wiki>		</sql2wiki>

2019-07-13T12:50:16Z

Mini Creatures of Legend, Myth and Terror

← Older revision		Revision as of 08:50, 13 July 2019
Line 187:		Line 187:
	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num, player FROM cards WHERE (year = 2009) AND (setname = "Topps Allen and Ginter's Mini Creatures")		SELECT num, player FROM cards WHERE (year = 2009) AND (setname = "Topps Allen and Ginter's Mini Creatures")
	ORDER BY num +0 ASC;		ORDER BY cast(substr(num,4) as unsigned) ASC;
	</sql2wiki>		</sql2wiki>