2004 Topps - Revision history

Stalegum: /* American Treasures Signatures */

2025-09-25T14:04:23Z

American Treasures Signatures

← Older revision		Revision as of 10:04, 25 September 2025
Line 544:		Line 544:
	===American Treasures Signatures===		===American Treasures Signatures===

	Each cut signature card is a one-of-one.		Each cut signature card is a one-of-one and exclusive to Series Two Hobby and HTA packs.

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

2025-09-25T14:04:04Z

American Treasures Presidential Signatures

← Older revision		Revision as of 10:04, 25 September 2025
Line 529:		Line 529:
	===American Treasures Presidential Signatures===		===American Treasures Presidential Signatures===

	Each is a one-of-one cut autograph.		Each is a one-of-one cut autograph and was exclusive to Series One Hobby and HTA packs.

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num,player FROM cards WHERE (year = 2004) AND (setname = 'Topps American Treasures Presidential Signatures');		SELECT num,player FROM cards WHERE (year = 2004) AND (setname = 'Topps American Treasures Presidential Signatures');
	</sql2wiki>		</sql2wiki>

	===American Treasures Presidential Signatures Dual===		===American Treasures Presidential Signatures Dual===

2025-09-25T14:01:46Z

World Series Highlights Autographs

← Older revision		Revision as of 10:01, 25 September 2025
Line 505:		Line 505:

	===World Series Highlights Autographs===		===World Series Highlights Autographs===

			====Series One====

	https://img.comc.com/i/Baseball/2004/Topps---World-Series-Highlights---Autographs-Autographed/WSA-BR/Brooks-Robinson.jpg?id=2f74986a-476d-4337-b31a-b19d7db4d83b&size=original&side=front&.jpg		https://img.comc.com/i/Baseball/2004/Topps---World-Series-Highlights---Autographs-Autographed/WSA-BR/Brooks-Robinson.jpg?id=2f74986a-476d-4337-b31a-b19d7db4d83b&size=original&side=front&.jpg
Line 510:		Line 512:

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num,player,~~info~~ FROM cards WHERE (year = 2004) AND (setname = 'Topps World Series Highlights Autographs');		SELECT num,player FROM cards WHERE (year = 2004) AND (setname = 'Topps World Series Highlights Autographs') AND (info = 1);
			</sql2wiki>
			====Series Two====

			https://img.comc.com/i/Baseball/2004/Topps---World-Series-Highlights---Autographs/WSA-BT/Bobby-Thomson.jpg?id=f3d6ea2e-c5a0-45b8-8571-6a992691a54a&size=original&side=front&.jpg
			https://img.comc.com/i/Baseball/2004/Topps---World-Series-Highlights---Autographs/WSA-BT/Bobby-Thomson.jpg?id=f3d6ea2e-c5a0-45b8-8571-6a992691a54a&size=original&side=back&.jpg

			<sql2wiki database="carddb">
			SELECT num,player FROM cards WHERE (year = 2004) AND (setname = 'Topps World Series Highlights Autographs') AND (info = 2);
	</sql2wiki>		</sql2wiki>

	===Team Topps Legends Autographs===		===Team Topps Legends Autographs===

2025-09-25T13:58:03Z

Autographs

@@ Line 465: / Line 465: @@
 </sql2wiki>
 ===Autographs===
 https://img.comc.com/i/Baseball/2004/Topps---Autographs/TA-IR/Ivan-Rodriguez.jpg?id=4ac9d955-c14a-4ed1-97f8-8443290729db&size=original&side=front&.jpg
 https://img.comc.com/i/Baseball/2004/Topps---Autographs/TA-IR/Ivan-Rodriguez.jpg?id=4ac9d955-c14a-4ed1-97f8-8443290729db&size=original&side=back&.jpg
 <sql2wiki database="carddb">
-SELECT num,player,info FROM cards WHERE (year = 2004) AND (setname = 'Topps Autographs');
+SELECT num,player,info FROM cards WHERE (year = 2004) AND (setname = 'Topps Autographs') AND (info LIKE '%2%');
 </sql2wiki>
 ===World Series Highlights Autographs===

2025-09-25T13:38:48Z

All-Star Patch Relics

← Older revision		Revision as of 09:38, 25 September 2025
Line 439:		Line 439:
	ORDER BY num ASC;		ORDER BY num ASC;
	</sql2wiki>		</sql2wiki>

	===Presidential First Pitch Seat Relics===		===Presidential First Pitch Seat Relics===

2025-09-24T16:06:37Z

Team Set Prospect Bonus

← Older revision		Revision as of 12:06, 24 September 2025
Line 387:		Line 387:
	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num,player FROM cards WHERE (year = 2004) AND (setname = 'Topps Team Set Prospect Bonus') AND (team = 'Astros');		SELECT num,player FROM cards WHERE (year = 2004) AND (setname = 'Topps Team Set Prospect Bonus') AND (team = 'Astros');
	</sql2wiki>		</sql2wiki>
	====Cubs====		====Cubs====

2025-09-24T16:04:26Z

Team Set Prospect Bonus

@@ Line 379: / Line 379: @@
 Topps produced four different "Team" factory sets -- Astros, Cubs, Red Sox, and Yankees -- that were only distributed only each team's immediate geographical area.  Each team set contained their own five-card Prospect Bonus set.
 <sql2wiki database="carddb">
-SELECT num,player FROM cards WHERE (year = 2004) AND (setname = 'Topps Team Set Prospect Bonus');
+SELECT num,player FROM cards WHERE (year = 2004) AND (setname = 'Topps Team Set Prospect Bonus') AND (team = 'Astros');
 </sql2wiki>

2020-07-04T15:40:02Z

Future Stars

← Older revision		Revision as of 11:40, 4 July 2020
Line 136:		Line 136:
	SELECT num,player FROM cards WHERE (year = 2004) AND (setname = 'Topps') AND (num BETWEEN 327 AND 331);		SELECT num,player FROM cards WHERE (year = 2004) AND (setname = 'Topps') AND (num BETWEEN 327 AND 331);
	</sql2wiki>		</sql2wiki>

	====Season Highlights====		====Season Highlights====

2020-02-04T17:00:12Z

Checklist

← Older revision		Revision as of 13:00, 4 February 2020
Line 97:		Line 97:
	=Checklist=		=Checklist=

			==Promos==

			<sql2wiki database="carddb">
			SELECT num,player,info FROM cards WHERE (year = 2004) AND (setname = 'Topps Pre-Production');
			</sql2wiki>
	==Base Set==		==Base Set==

2020-02-04T16:55:46Z

American Treasures Signatures

← Older revision		Revision as of 12:55, 4 February 2020
Line 467:		Line 467:

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num,player FROM cards WHERE (year = 2004) AND (setname = 'Topps American Treasures Signatures');		SELECT num,player FROM cards WHERE (year = 2004) AND (setname = 'Topps American Treasures Signatures')
			ORDER BY num ASC;
	</sql2wiki>		</sql2wiki>

	===American Treasures Signatures Dual===		===American Treasures Signatures Dual===