2007 Topps Moments & Milestones - Revision history

Stalegum: /* Rookie Subset */

2011-05-29T20:25:37Z

Rookie Subset

← Older revision		Revision as of 16:25, 29 May 2011
Line 77:		Line 77:
	===Rookie Subset===		===Rookie Subset===

	NOTE: Unlike the rest of the set, only one version of each card exists. Each card is serial-numbered to 150 copies.		NOTE: Unlike the rest of the set, only one version of each card exists; however, there are three separate cards of each player. Each card is serial-numbered to 150 copies.

	<sql2wiki database="carddb">		<sql2wiki database="carddb">

2011-05-29T20:20:51Z

Base Set

← Older revision		Revision as of 16:20, 29 May 2011
Line 66:		Line 66:
	==Base Set==		==Base Set==

	NOTE: For brevity's sake, we can not possibly list all 12,475 ~~variations~~. ~~Therefore, we have listed~~ besides each player's name the number of different variations of that particular card ~~that are~~ available, as well as the statistic accomplished.		NOTE: For brevity's sake, we can not possibly list all 12,475 cards. Listed besides each player's name is the number of different variations of that particular base card available, as well as the statistic accomplished.

	Each card is serial-numbered to 150 copies.		Each card is serial-numbered to 150 copies.

2011-05-29T20:18:37Z

Base Set

← Older revision		Revision as of 16:18, 29 May 2011
Line 66:		Line 66:
	==Base Set==		==Base Set==

	NOTE: For brevity's sake, we can not possibly list all 12,475 variations. Therefore, we have listed besides each player's name the number of different variations of that particular card that are available.		NOTE: For brevity's sake, we can not possibly list all 12,475 variations. Therefore, we have listed besides each player's name the number of different variations of that particular card that are available, as well as the statistic accomplished.

	Each card is serial-numbered to 150 copies.		Each card is serial-numbered to 150 copies.

2011-05-29T20:16:35Z

Milestone Autographs

← Older revision		Revision as of 16:16, 29 May 2011
Line 116:		Line 116:
	===Milestone Autographs===		===Milestone Autographs===

	~~Each~~ Milestone ~~Autograph is~~ NOT serial-numbered; ~~but~~ available in the following parallels.		Like the Rookie Autographs, the Milestone Autographs are NOT serial-numbered; however, Topps did announce that only 200 copies of each group "E" and 100 of each group "F" autograph were produced.

			Each card is available in the following parallels.

	* Black (serial-numbered to 40 copies)		* Black (serial-numbered to 40 copies)

2011-05-29T20:14:29Z

Milestone Autographs

← Older revision		Revision as of 16:14, 29 May 2011
Line 125:		Line 125:

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num,player,info FROM cards WHERE (year = 2007) AND (setname = 'Topps Moments and Milestones Milestone Autographs')		SELECT num,player,info,serial FROM cards WHERE (year = 2007) AND (setname = 'Topps Moments and Milestones Milestone Autographs')
	ORDER BY num ASC;		ORDER BY num ASC;
	</sql2wiki>		</sql2wiki>
	[[Category:Topps]]		[[Category:Topps]]
	[[Category:2007]]		[[Category:2007]]

2011-05-29T19:15:23Z

Rookie Subset

← Older revision		Revision as of 15:15, 29 May 2011
Line 78:		Line 78:

	NOTE: Unlike the rest of the set, only one version of each card exists. Each card is serial-numbered to 150 copies.		NOTE: Unlike the rest of the set, only one version of each card exists. Each card is serial-numbered to 150 copies.

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num,player,info FROM cards WHERE year = 2007 AND setname = 'Topps Moments and Milestones' AND num > 169;		SELECT num,player,info FROM cards WHERE year = 2007 AND setname = 'Topps Moments and Milestones' AND num > 169;

2011-05-29T19:13:23Z

Rookie Subset

← Older revision		Revision as of 15:13, 29 May 2011
Line 79:		Line 79:
	NOTE: Unlike the rest of the set, only one version of each card exists. Each card is serial-numbered to 150 copies.		NOTE: Unlike the rest of the set, only one version of each card exists. Each card is serial-numbered to 150 copies.
	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num,player,info FROM cards WHERE setname = 'Topps Moments and Milestones' AND num > 169;		SELECT num,player,info FROM cards WHERE year = 2007 AND setname = 'Topps Moments and Milestones' AND num > 169;
	</sql2wiki>		</sql2wiki>

2011-05-29T19:11:20Z

Base Set

← Older revision		Revision as of 15:11, 29 May 2011
Line 67:		Line 67:

	NOTE: For brevity's sake, we can not possibly list all 12,475 variations. Therefore, we have listed besides each player's name the number of different variations of that particular card that are available.		NOTE: For brevity's sake, we can not possibly list all 12,475 variations. Therefore, we have listed besides each player's name the number of different variations of that particular card that are available.

			Each card is serial-numbered to 150 copies.

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT SUBSTRING_INDEX(num, '-',1),player,COUNT(num),SUBSTRING_INDEX(info, '-', 1)		SELECT SUBSTRING_INDEX(num, '-',1),player,COUNT(num),SUBSTRING_INDEX(info, '-', 1)
	FROM cards		FROM cards WHERE setname = 'Topps Moments and Milestones' AND year = 2007 AND num < 170
	WHERE setname="Topps Moments and Milestones" AND year= 2007 AND num < 170
	GROUP BY SUBSTRING_INDEX(num, '-',1) ORDER BY num +0 ASC;		GROUP BY SUBSTRING_INDEX(num, '-',1) ORDER BY num +0 ASC;
	</sql2wiki>		</sql2wiki>
			===Rookie Subset===

			NOTE: Unlike the rest of the set, only one version of each card exists. Each card is serial-numbered to 150 copies.
	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num,player,info FROM cards WHERE setname = 'Topps Moments and Milestones' AND num > 169;		SELECT num,player,info FROM cards WHERE setname = 'Topps Moments and Milestones' AND num > 169;

2011-05-29T19:05:11Z

Base Set

← Older revision		Revision as of 15:05, 29 May 2011
Line 69:		Line 69:

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT SUBSTRING_INDEX(num, '-',		SELECT SUBSTRING_INDEX(num, '-',1),player,COUNT(num),SUBSTRING_INDEX(info, '-', 1)
	1),player,COUNT(num),SUBSTRING_INDEX(info, '-', 1)		FROM cards
	FROM cards WHERE setname="Topps Moments and Milestones" AND		WHERE setname="Topps Moments and Milestones" AND year= 2007 AND num < 170
	year="2007" GROUP BY SUBSTRING_INDEX(num, '-',1) ORDER BY num +0 ASC		GROUP BY SUBSTRING_INDEX(num, '-',1) ORDER BY num +0 ASC;
			</sql2wiki>

			<sql2wiki database="carddb">
			SELECT num,player,info FROM cards WHERE setname = 'Topps Moments and Milestones' AND num > 169;
	</sql2wiki>		</sql2wiki>

2011-05-29T14:51:38Z

← Older revision		Revision as of 10:51, 29 May 2011
Line 69:		Line 69:

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT SUBSTRING_INDEX(num,'-',1),player,COUNT(num),SUBSTRING_INDEX(info,'-',1)		SELECT SUBSTRING_INDEX(num, '-',
	FROM cards WHERE setname = 'Topps Moments and Milestones' AND year = 2007		1),player,COUNT(num),SUBSTRING_INDEX(info, '-', 1)
	GROUP BY ~~player~~ ORDER BY num +0 ASC;		FROM cards WHERE setname="Topps Moments and Milestones" AND
			year="2007" GROUP BY SUBSTRING_INDEX(num, '-',1) ORDER BY num +0 ASC
	</sql2wiki>		</sql2wiki>