2001 Upper Deck Decade 1970's - Revision history

Stalegum: /* Jersey Patch */

2025-04-28T18:42:13Z

Jersey Patch

← Older revision		Revision as of 14:42, 28 April 2025
Line 161:		Line 161:

	===Jersey Patch===		===Jersey Patch===

			'''NOTE:''' A card of Carlton Fisk was on the checklist issued by Upper Deck (#P-CF), but has never emerged.

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
Line 166:		Line 168:
	ORDER BY num ASC;		ORDER BY num ASC;
	</sql2wiki>		</sql2wiki>

	===Game Bat Combos===		===Game Bat Combos===

Stalegum: /* Autographs & Game-Used */

2025-04-28T18:41:12Z

Autographs & Game-Used

← Older revision		Revision as of 14:41, 28 April 2025
Line 138:		Line 138:

	==Autographs & Game-Used==		==Autographs & Game-Used==

			'''NOTE:''' None of these cards are serial-numbered; however, Upper Deck did release production figures for selected cards, which are listed below.

	===Game Bat===		===Game Bat===

Stalegum: /* Jersey */

2025-04-28T18:37:33Z

Jersey

← Older revision		Revision as of 14:37, 28 April 2025
Line 154:		Line 154:

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num,player,info,serial FROM cards WHERE (year = 2001) AND (setname = 'Upper Deck Decade 1970\'s Jersey')		SELECT num,player,info,serial FROM cards WHERE (year = 2001) AND (setname = 'Upper Deck Decade 1970\'s Game Jersey')
	ORDER BY num ASC;		ORDER BY num ASC;
	</sql2wiki>		</sql2wiki>

	===Jersey Patch===		===Jersey Patch===

Stalegum: /* Autographs & Game-Used */

2025-04-28T18:35:59Z

Autographs & Game-Used

← Older revision		Revision as of 14:35, 28 April 2025
Line 145:		Line 145:

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num,player,info,serial FROM cards WHERE (year = 2001) AND (setname = 'Upper Deck Decade 1970\'s Game Bat');		SELECT num,player,info,serial FROM cards WHERE (year = 2001) AND (setname = 'Upper Deck Decade 1970\'s Game Bat')
			ORDER BY num ASC;
	</sql2wiki>		</sql2wiki>
	===Jersey===		===Jersey===
Line 159:		Line 160:

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num,player,info,serial FROM cards WHERE (year = 2001) AND (setname = 'Upper Deck Decade 1970\'s Game Jersey Patch');		SELECT num,player,info,serial FROM cards WHERE (year = 2001) AND (setname = 'Upper Deck Decade 1970\'s Game Jersey Patch')
			ORDER BY num ASC;
	</sql2wiki>		</sql2wiki>
	===Game Bat Combos===		===Game Bat Combos===
Line 170:		Line 172:
	ORDER BY num ASC;		ORDER BY num ASC;
	</sql2wiki>		</sql2wiki>

	===Game Jersey Autograph===		===Game Jersey Autograph===

Line 177:		Line 178:

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num,player,info,serial FROM cards WHERE (year = 2001) AND (setname = 'Upper Deck Decade 1970\'s Game Jersey ~~Autograph~~');		SELECT num,player,info,serial FROM cards WHERE (year = 2001) AND (setname = 'Upper Deck Decade 1970\'s Autographed Game Jersey')
			ORDER BY num ASC;
	</sql2wiki>		</sql2wiki>
	[[Category:Upper Deck]]		[[Category:Upper Deck]]
	[[Category:2001]]		[[Category:2001]]

Stalegum: /* Game Bat Combos */

2025-04-28T18:35:10Z

Game Bat Combos

← Older revision		Revision as of 14:35, 28 April 2025
Line 167:		Line 167:

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num,player,info,serial FROM cards WHERE (year = 2001) AND (setname = 'Upper Deck Decade 1970\'s Game Bat Combos');		SELECT num,player,info,serial FROM cards WHERE (year = 2001) AND (setname = 'Upper Deck Decade 1970\'s Game Bat Combos')
			ORDER BY num ASC;
	</sql2wiki>		</sql2wiki>

Stalegum: /* Game Bat Combos */

2025-04-28T18:34:57Z

Game Bat Combos

← Older revision		Revision as of 14:34, 28 April 2025
Line 169:		Line 169:
	SELECT num,player,info,serial FROM cards WHERE (year = 2001) AND (setname = 'Upper Deck Decade 1970\'s Game Bat Combos');		SELECT num,player,info,serial FROM cards WHERE (year = 2001) AND (setname = 'Upper Deck Decade 1970\'s Game Bat Combos');
	</sql2wiki>		</sql2wiki>

	===Game Jersey Autograph===		===Game Jersey Autograph===

Stalegum: /* Autographs & Game-Used */

2025-04-28T18:30:59Z

Autographs & Game-Used

← Older revision		Revision as of 14:30, 28 April 2025
Line 145:		Line 145:

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num,player FROM cards WHERE (year = 2001) AND (setname = 'Upper Deck Decade 1970\'s Game Bat');		SELECT num,player,info,serial FROM cards WHERE (year = 2001) AND (setname = 'Upper Deck Decade 1970\'s Game Bat');
	</sql2wiki>		</sql2wiki>
	===Jersey===		===Jersey===
Line 153:		Line 153:

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num,player FROM cards WHERE (year = 2001) AND (setname = 'Upper Deck Decade 1970\'s Jersey')		SELECT num,player,info,serial FROM cards WHERE (year = 2001) AND (setname = 'Upper Deck Decade 1970\'s Jersey')
	ORDER BY num ASC;		ORDER BY num ASC;
	</sql2wiki>		</sql2wiki>
Line 159:		Line 159:

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num,player FROM cards WHERE (year = 2001) AND (setname = 'Upper Deck Decade 1970\'s Game Jersey Patch');		SELECT num,player,info,serial FROM cards WHERE (year = 2001) AND (setname = 'Upper Deck Decade 1970\'s Game Jersey Patch');
	</sql2wiki>		</sql2wiki>
	===Game Bat Combos===		===Game Bat Combos===
Line 167:		Line 167:

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num,player FROM cards WHERE (year = 2001) AND (setname = 'Upper Deck Decade 1970\'s Game Bat Combos');		SELECT num,player,info,serial FROM cards WHERE (year = 2001) AND (setname = 'Upper Deck Decade 1970\'s Game Bat Combos');
	</sql2wiki>		</sql2wiki>
	===Game Jersey Autograph===		===Game Jersey Autograph===
Line 175:		Line 175:

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num,player FROM cards WHERE (year = 2001) AND (setname = 'Upper Deck Decade 1970\'s Game Jersey Autograph');		SELECT num,player,info,serial FROM cards WHERE (year = 2001) AND (setname = 'Upper Deck Decade 1970\'s Game Jersey Autograph');
	</sql2wiki>		</sql2wiki>
	[[Category:Upper Deck]]		[[Category:Upper Deck]]
	[[Category:2001]]		[[Category:2001]]

Stalegum: /* Base Set */

2025-04-28T18:04:11Z

Base Set

← Older revision		Revision as of 14:04, 28 April 2025
Line 58:		Line 58:
	===Rookie Flashbacks===		===Rookie Flashbacks===

			https://img.comc.com/i/Baseball/2001/Upper-Deck-Decade-1970s---Base/93/Fred-Lynn.jpg?id=0592f34b-b81b-4d3c-84ad-8bd35bf4d615&size=original&side=front&.jpg
			https://img.comc.com/i/Baseball/2001/Upper-Deck-Decade-1970s---Base/93/Fred-Lynn.jpg?id=0592f34b-b81b-4d3c-84ad-8bd35bf4d615&size=original&side=back&.jpg

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
Line 64:		Line 66:
	</sql2wiki>		</sql2wiki>

	===Decade Dateline====		===Decade Dateline===

			https://img.comc.com/i/Baseball/2001/Upper-Deck-Decade-1970s---Base/117/Roberto-Clemente.jpg?id=48431b77-19c9-431a-bb18-6d5251ee3ddc&size=original&side=front&.jpg
			https://img.comc.com/i/Baseball/2001/Upper-Deck-Decade-1970s---Base/117/Roberto-Clemente.jpg?id=48431b77-19c9-431a-bb18-6d5251ee3ddc&size=original&side=back&.jpg

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
Line 71:		Line 75:
	ORDER BY num +0 ASC;		ORDER BY num +0 ASC;
	</sql2wiki>		</sql2wiki>
	===Award Winners====		===Award Winners===

			https://img.comc.com/i/Baseball/2001/Upper-Deck-Decade-1970s---Base/155/Mike-Hargrove.jpg?id=5b38ed45-f39f-4284-96b8-8afceb5abb34&size=original&side=front&.jpg
			https://img.comc.com/i/Baseball/2001/Upper-Deck-Decade-1970s---Base/155/Mike-Hargrove.jpg?id=5b38ed45-f39f-4284-96b8-8afceb5abb34&size=original&side=back&.jpg

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
Line 78:		Line 84:
	ORDER BY num +0 ASC;		ORDER BY num +0 ASC;
	</sql2wiki>		</sql2wiki>
	===World Series Highlights====		===World Series Highlights===

			https://img.comc.com/i/Baseball/2001/Upper-Deck-Decade-1970s---Base/174/Reggie-Jackson.jpg?id=53f3ef4f-f1b9-4cb8-8595-eb3f20c6931b&size=original&side=front&.jpg
			https://img.comc.com/i/Baseball/2001/Upper-Deck-Decade-1970s---Base/174/Reggie-Jackson.jpg?id=53f3ef4f-f1b9-4cb8-8595-eb3f20c6931b&size=original&side=back&.jpg

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

Stalegum: /* Rookie Flashbacks= */

2025-04-28T18:01:52Z

Rookie Flashbacks=

← Older revision		Revision as of 14:01, 28 April 2025
Line 56:		Line 56:
	ORDER BY num +0 ASC;		ORDER BY num +0 ASC;
	</sql2wiki>		</sql2wiki>
	===Rookie Flashbacks====		===Rookie Flashbacks===


Line 63:		Line 63:
	ORDER BY num +0 ASC;		ORDER BY num +0 ASC;
	</sql2wiki>		</sql2wiki>

	===Decade Dateline====		===Decade Dateline====

Stalegum: /* Base Set */

2025-04-28T18:01:44Z

Base Set

@@ Line 53: / Line 53: @@
 <sql2wiki database="carddb">
-SELECT num,player FROM cards WHERE (year = 2001) AND (setname = 'Upper Deck Decade 1970\'s')
+SELECT num,player FROM cards WHERE (year = 2001) AND (setname = 'Upper Deck Decade 1970\'s') AND (num < 91)
 ORDER BY num +0 ASC;
 </sql2wiki>
 ==Inserts==