2006 Ultimate Collection - Revision history

Stalegum: /* Tandem Materials Signatures */

2019-06-21T01:39:29Z

Tandem Materials Signatures

← Older revision		Revision as of 21:39, 20 June 2019
Line 369:		Line 369:

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num,player,info~~,serial~~ FROM cards WHERE (year = 2006) AND (setname = 'Ultimate Collection Tandem Materials Signatures');		SELECT num,player,info FROM cards WHERE (year = 2006) AND (setname = 'Ultimate Collection Tandem Materials Signatures');
	</sql2wiki>		</sql2wiki>
	====Patch====		====Patch====
Line 376:		Line 376:

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num,player,info~~,serial~~ FROM cards WHERE (year = 2006) AND (setname = 'Ultimate Collection Tandem Materials Signatures Patch');		SELECT num,player,info FROM cards WHERE (year = 2006) AND (setname = 'Ultimate Collection Tandem Materials Signatures Patch');
	</sql2wiki>		</sql2wiki>
	====Logo====		====Logo====
Line 383:		Line 383:

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num,player,info~~,serial~~ FROM cards WHERE (year = 2006) AND (setname = 'Ultimate Collection Tandem Materials Signatures Logo');		SELECT num,player,info FROM cards WHERE (year = 2006) AND (setname = 'Ultimate Collection Tandem Materials Signatures Logo');
	</sql2wiki>		</sql2wiki>
	{{Ultimate Collection}}		{{Ultimate Collection}}
	[[Category:Upper Deck]]		[[Category:Upper Deck]]
	[[Category:2006]]		[[Category:2006]]

2019-06-21T01:39:00Z

Patch Signatures

← Older revision		Revision as of 21:39, 20 June 2019
Line 358:		Line 358:

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num,player,info~~,serial~~ FROM cards WHERE (year = 2006) AND (setname = 'Ultimate Collection Patch Signatures');		SELECT num,player,info FROM cards WHERE (year = 2006) AND (setname = 'Ultimate Collection Patch Signatures');
	</sql2wiki>		</sql2wiki>

	===Tandem Materials Signatures===		===Tandem Materials Signatures===

2019-06-21T01:38:47Z

Game Materials Signatures

← Older revision		Revision as of 21:38, 20 June 2019
Line 347:		Line 347:

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num,player,info~~,serial~~ FROM cards WHERE (year = 2006) AND (setname = 'Ultimate Collection Game Materials Signatures');		SELECT num,player,info FROM cards WHERE (year = 2006) AND (setname = 'Ultimate Collection Game Materials Signatures');
	</sql2wiki>		</sql2wiki>

	===Patch Signatures===		===Patch Signatures===

2019-06-21T01:38:13Z

Eight

← Older revision		Revision as of 21:38, 20 June 2019
Line 308:		Line 308:

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num,player,info FROM cards WHERE (year = 2006) AND (setname = 'Ultimate Collection Ensemble Signatures Eight');		SELECT num,player,info FROM cards WHERE (year = 2006) AND (setname = 'Ultimate Collection Ensemble Signatures Eight')
			ORDER BY (SUBSTRING(num FROM 6)) +0 ASC;
	</sql2wiki>		</sql2wiki>

	===Legendary Ensemble Signatures===		===Legendary Ensemble Signatures===

2019-06-21T01:37:29Z

Six

← Older revision		Revision as of 21:37, 20 June 2019
Line 299:		Line 299:

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num,player,info FROM cards WHERE (year = 2006) AND (setname = 'Ultimate Collection Ensemble Signatures Six');		SELECT num,player,info FROM cards WHERE (year = 2006) AND (setname = 'Ultimate Collection Ensemble Signatures Six')
			ORDER BY (SUBSTRING(num FROM 6)) +0 ASC;
	</sql2wiki>		</sql2wiki>

	====Eight====		====Eight====

2019-06-21T01:36:43Z

Five

← Older revision		Revision as of 21:36, 20 June 2019
Line 290:		Line 290:

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num,player,info FROM cards WHERE (year = 2006) AND (setname = 'Ultimate Collection Ensemble Signatures Five');		SELECT num,player,info FROM cards WHERE (year = 2006) AND (setname = 'Ultimate Collection Ensemble Signatures Five')
			ORDER BY (SUBSTRING(num FROM 6)) +0 ASC;
	</sql2wiki>		</sql2wiki>

	====Six====		====Six====

2019-06-21T01:36:20Z

Quad

← Older revision		Revision as of 21:36, 20 June 2019
Line 281:		Line 281:

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num,player,info FROM cards WHERE (year = 2006) AND (setname = 'Ultimate Collection Ensemble Signatures Quad');		SELECT num,player,info FROM cards WHERE (year = 2006) AND (setname = 'Ultimate Collection Ensemble Signatures Quad')
			ORDER BY (SUBSTRING(num FROM 6)) +0 ASC;
	</sql2wiki>		</sql2wiki>

	====Five====		====Five====

2019-06-21T01:35:48Z

"15"

← Older revision		Revision as of 21:35, 20 June 2019
Line 270:		Line 270:

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num,player,info FROM cards WHERE (year = 2006) AND (setname = 'Ultimate Collection Ensemble Signatures Triple 15');		SELECT num,player,info FROM cards WHERE (year = 2006) AND (setname = 'Ultimate Collection Ensemble Signatures Triple "15"');
	</sql2wiki>		</sql2wiki>

	====Quad====		====Quad====

2019-06-21T01:35:10Z

Maximum Materials

← Older revision		Revision as of 21:35, 20 June 2019
Line 227:		Line 227:

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num,player~~,info,serial~~ FROM cards WHERE (year = 2006) AND (setname = 'Ultimate Collection Maximum Materials');		SELECT num,player FROM cards WHERE (year = 2006) AND (setname = 'Ultimate Collection Maximum Materials');
	</sql2wiki>		</sql2wiki>
	====Patch====		====Patch====
Line 237:		Line 237:

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num,player~~,info,serial~~ FROM cards WHERE (year = 2006) AND (setname = 'Ultimate Collection Maximum Materials Patch');		SELECT num,player FROM cards WHERE (year = 2006) AND (setname = 'Ultimate Collection Maximum Materials Patch');
	</sql2wiki>		</sql2wiki>

	===Legendary Materials===		===Legendary Materials===

2019-06-21T01:34:40Z

Ensemble Materials Quad

← Older revision		Revision as of 21:34, 20 June 2019
Line 209:		Line 209:

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num,player~~,info,serial~~ FROM cards WHERE (year = 2006) AND (setname = 'Ultimate Collection Ensemble Materials Quad');		SELECT num,player FROM cards WHERE (year = 2006) AND (setname = 'Ultimate Collection Ensemble Materials Quad');
	</sql2wiki>		</sql2wiki>
	====Patch====		====Patch====
Line 216:		Line 216:

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num,player~~,info,serial~~ FROM cards WHERE (year = 2006) AND (setname = 'Ultimate Collection Ensemble Materials Quad Patch');		SELECT num,player FROM cards WHERE (year = 2006) AND (setname = 'Ultimate Collection Ensemble Materials Quad Patch');
	</sql2wiki>		</sql2wiki>

	===Maximum Materials===		===Maximum Materials===