2008 Upper Deck Ballpark Collection - Revision history

Stalegum: /* Base Set */

2019-06-11T13:42:36Z

Base Set

← Older revision		Revision as of 09:42, 11 June 2019
Line 48:		Line 48:
	https://img.comc.com/i/Baseball/2008/Upper-Deck-Ballpark-Collection---Base/42/Roy-Oswalt.jpg?id=3a821823-e003-4d54-b0f0-eb54de4175ee&size=original&side=front&.jpg		https://img.comc.com/i/Baseball/2008/Upper-Deck-Ballpark-Collection---Base/42/Roy-Oswalt.jpg?id=3a821823-e003-4d54-b0f0-eb54de4175ee&size=original&side=front&.jpg
	https://img.comc.com/i/Baseball/2008/Upper-Deck-Ballpark-Collection---Base/42/Roy-Oswalt.jpg?id=3a821823-e003-4d54-b0f0-eb54de4175ee&size=original&side=back&.jpg		https://img.comc.com/i/Baseball/2008/Upper-Deck-Ballpark-Collection---Base/42/Roy-Oswalt.jpg?id=3a821823-e003-4d54-b0f0-eb54de4175ee&size=original&side=back&.jpg

			'''NOTE:''' The Ballpark Collection base set is skip-numbered -- especially in the multi-swatch memorabilia card subsets.

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
Line 64:		Line 66:
	ORDER BY num +0 ASC;		ORDER BY num +0 ASC;
	</sql2wiki>		</sql2wiki>

	===Dual Swatch Memorabilia===		===Dual Swatch Memorabilia===

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

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

Stalegum: /* Autographs & Game-Used */

2019-06-05T12:44:17Z

Autographs & Game-Used

← Older revision		Revision as of 08:44, 5 June 2019
Line 111:		Line 111:

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num,player,info,serial FROM cards WHERE (year = 2008) AND (setname LIKE 'Upper Deck Ballpark Collection Jersey Buttons');		SELECT num,player,info,serial FROM cards WHERE (year = 2008) AND (setname LIKE 'Upper Deck Ballpark Collection Jersey Buttons')
			ORDER BY (SUBSTRING(num FROM 4)) +0 ASC;
	</sql2wiki>		</sql2wiki>
	===Jersey Laundry Tag===		===Jersey Laundry Tag===
Line 119:		Line 120:

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num,player,info,serial FROM cards WHERE (year = 2008) AND (setname LIKE 'Upper Deck Ballpark Collection Jersey Laundry Tag');		SELECT num,player,info,serial FROM cards WHERE (year = 2008) AND (setname LIKE 'Upper Deck Ballpark Collection Jersey Laundry Tag')
			ORDER BY (SUBSTRING(num FROM 4)) +0 ASC;
	</sql2wiki>		</sql2wiki>
	===Jersey MLB Logo===		===Jersey MLB Logo===

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num,player,info,serial FROM cards WHERE (year = 2008) AND (setname LIKE 'Upper Deck Ballpark Collection Jersey MLB Logo');		SELECT num,player,info,serial FROM cards WHERE (year = 2008) AND (setname LIKE 'Upper Deck Ballpark Collection Jersey MLB Logo')
			ORDER BY (SUBSTRING(num FROM 4)) +0 ASC;
	</sql2wiki>		</sql2wiki>
	===Jersey Autographs===		===Jersey Autographs===
Line 132:		Line 135:

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num,player,info,serial FROM cards WHERE (year = 2008) AND (setname LIKE 'Upper Deck Ballpark Collection Jersey Autographs');		SELECT num,player,info,serial FROM cards WHERE (year = 2008) AND (setname LIKE 'Upper Deck Ballpark Collection Jersey Autographs')
			ORDER BY (SUBSTRING(num FROM 4)) +0 ASC;
	</sql2wiki>		</sql2wiki>
	===Dual Memorabilia Autographs===		===Dual Memorabilia Autographs===

Stalegum: /* Checklist */

2019-06-05T12:43:13Z

Checklist

← Older revision		Revision as of 08:43, 5 June 2019
Line 50:		Line 50:

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num,player,info,serial FROM cards WHERE (year = 2008) AND (setname LIKE 'Upper Deck Ballpark Collection') AND (num < 101);		SELECT num,player,info,serial FROM cards WHERE (year = 2008) AND (setname LIKE 'Upper Deck Ballpark Collection') AND (num < 101)
			ORDER BY num +0 ASC;
	</sql2wiki>		</sql2wiki>
	===Rookie Autographs===		===Rookie Autographs===
Line 60:		Line 61:

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num,player,info,serial FROM cards WHERE (year = 2008) AND (setname LIKE 'Upper Deck Ballpark Collection') AND (num BETWEEN 101 AND 150);		SELECT num,player,info,serial FROM cards WHERE (year = 2008) AND (setname LIKE 'Upper Deck Ballpark Collection') AND (num BETWEEN 101 AND 150)
			ORDER BY num +0 ASC;
	</sql2wiki>		</sql2wiki>

Line 69:		Line 71:

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num,player,info,serial FROM cards WHERE (year = 2008) AND (setname LIKE 'Upper Deck Ballpark Collection') AND (num BETWEEN 151 AND 200);		SELECT num,player,info,serial FROM cards WHERE (year = 2008) AND (setname LIKE 'Upper Deck Ballpark Collection') AND (num BETWEEN 151 AND 200)
			ORDER BY num +0 ASC;
	</sql2wiki>		</sql2wiki>
	===Quad Swatch Memorabilia===		===Quad Swatch Memorabilia===
Line 77:		Line 80:

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num,player,info,serial FROM cards WHERE (year = 2008) AND (setname LIKE 'Upper Deck Ballpark Collection') AND (num BETWEEN 201 AND 250);		SELECT num,player,info,serial FROM cards WHERE (year = 2008) AND (setname LIKE 'Upper Deck Ballpark Collection') AND (num BETWEEN 201 AND 250)
			ORDER BY num +0 ASC;
	</sql2wiki>		</sql2wiki>
	===Six Swatch Memorabilia===		===Six Swatch Memorabilia===
Line 87:		Line 91:

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num,player,info,serial FROM cards WHERE (year = 2008) AND (setname LIKE 'Upper Deck Ballpark Collection') AND (num BETWEEN 251 AND 295);		SELECT num,player,info,serial FROM cards WHERE (year = 2008) AND (setname LIKE 'Upper Deck Ballpark Collection') AND (num BETWEEN 251 AND 295)
			ORDER BY num +0 ASC;
	</sql2wiki>		</sql2wiki>

	===Eight Swatch Memorabilia===		===Eight Swatch Memorabilia===

Line 96:		Line 100:

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num,player,info,serial FROM cards WHERE (year = 2008) AND (setname LIKE 'Upper Deck Ballpark Collection') AND (num > 296);		SELECT num,player,info,serial FROM cards WHERE (year = 2008) AND (setname LIKE 'Upper Deck Ballpark Collection') AND (num > 296)
			ORDER BY num +0 ASC;
	</sql2wiki>		</sql2wiki>
	==Autographs & Game-Used==		==Autographs & Game-Used==

Stalegum: /* Six Swatch Memorabilia */

2019-06-04T21:03:21Z

Six Swatch Memorabilia

← Older revision		Revision as of 17:03, 4 June 2019
Line 83:		Line 83:
	https://img.comc.com/i/Baseball/2008/Upper-Deck-Ballpark-Collection---Six-Swatches-Memorabilia/WLRJHT/Kerry-Wood-Derrek-Lee-Aramis-Ramirez-Randy-Johnson-Dan-Haren-Chad-Tracy.jpg?id=006957dc-aeec-4e20-b709-b9c85201c522&size=original&side=front&.jpg		https://img.comc.com/i/Baseball/2008/Upper-Deck-Ballpark-Collection---Six-Swatches-Memorabilia/WLRJHT/Kerry-Wood-Derrek-Lee-Aramis-Ramirez-Randy-Johnson-Dan-Haren-Chad-Tracy.jpg?id=006957dc-aeec-4e20-b709-b9c85201c522&size=original&side=front&.jpg
	https://img.comc.com/i/Baseball/2008/Upper-Deck-Ballpark-Collection---Six-Swatches-Memorabilia/WLRJHT/Kerry-Wood-Derrek-Lee-Aramis-Ramirez-Randy-Johnson-Dan-Haren-Chad-Tracy.jpg?id=006957dc-aeec-4e20-b709-b9c85201c522&size=original&side=back&.jpg		https://img.comc.com/i/Baseball/2008/Upper-Deck-Ballpark-Collection---Six-Swatches-Memorabilia/WLRJHT/Kerry-Wood-Derrek-Lee-Aramis-Ramirez-Randy-Johnson-Dan-Haren-Chad-Tracy.jpg?id=006957dc-aeec-4e20-b709-b9c85201c522&size=original&side=back&.jpg

			'''NOTE:''' Each Six Swatch and Eight Swatch Memorabilia card has a unique UD Authenticated serial number and was packaged with a UDA certificate of authenticity, with a matching serial number.

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num,player,info,serial FROM cards WHERE (year = 2008) AND (setname LIKE 'Upper Deck Ballpark Collection') AND (num BETWEEN 251 AND 295);		SELECT num,player,info,serial FROM cards WHERE (year = 2008) AND (setname LIKE 'Upper Deck Ballpark Collection') AND (num BETWEEN 251 AND 295);
	</sql2wiki>		</sql2wiki>

	===Eight Swatch Memorabilia===		===Eight Swatch Memorabilia===

Stalegum: /* Rookie Autographs */

2019-06-04T19:54:53Z

Rookie Autographs

← Older revision		Revision as of 15:54, 4 June 2019
Line 56:		Line 56:
	https://img.comc.com/i/Baseball/2008/Upper-Deck-Ballpark-Collection---Base/116/Rookie-Autographs---Colt-Morton.jpg?id=45fe0bfb-729c-46e1-b47d-ca69ae27262a&size=original&side=front&.jpg		https://img.comc.com/i/Baseball/2008/Upper-Deck-Ballpark-Collection---Base/116/Rookie-Autographs---Colt-Morton.jpg?id=45fe0bfb-729c-46e1-b47d-ca69ae27262a&size=original&side=front&.jpg
	https://img.comc.com/i/Baseball/2008/Upper-Deck-Ballpark-Collection---Base/116/Rookie-Autographs---Colt-Morton.jpg?id=45fe0bfb-729c-46e1-b47d-ca69ae27262a&size=original&side=back&.jpg		https://img.comc.com/i/Baseball/2008/Upper-Deck-Ballpark-Collection---Base/116/Rookie-Autographs---Colt-Morton.jpg?id=45fe0bfb-729c-46e1-b47d-ca69ae27262a&size=original&side=back&.jpg

			'''NOTE:''' Redemption cards expired August 27th, 2010.

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num,player,info,serial FROM cards WHERE (year = 2008) AND (setname LIKE 'Upper Deck Ballpark Collection') AND (num BETWEEN 101 AND 150);		SELECT num,player,info,serial FROM cards WHERE (year = 2008) AND (setname LIKE 'Upper Deck Ballpark Collection') AND (num BETWEEN 101 AND 150);
	</sql2wiki>		</sql2wiki>

	===Dual Swatch Memorabilia===		===Dual Swatch Memorabilia===

Stalegum: /* Dual Memorabilia Autographs */

2019-06-04T19:53:59Z

Dual Memorabilia Autographs

← Older revision		Revision as of 15:53, 4 June 2019
Line 124:		Line 124:
	</sql2wiki>		</sql2wiki>
	===Dual Memorabilia Autographs===		===Dual Memorabilia Autographs===

			This seven-card set is an autographed partial-parallel.

			'''NOTE:''' Card #189 does not exist in the base set.

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT num,player,info~~,serial~~ FROM cards WHERE (year = 2008) AND (setname LIKE 'Upper Deck Ballpark Collection Dual Memorabilia Autographs');		SELECT num,player,info FROM cards WHERE (year = 2008) AND (setname LIKE 'Upper Deck Ballpark Collection Dual Memorabilia Autographs');
	</sql2wiki>		</sql2wiki>
	[[Category:Upper Deck]]		[[Category:Upper Deck]]
	[[Category:2008]]		[[Category:2008]]

Stalegum: /* Checklist */

2019-06-04T19:49:10Z

Checklist

← Older revision		Revision as of 15:49, 4 June 2019
Line 45:		Line 45:

	==Base Set==		==Base Set==

			https://img.comc.com/i/Baseball/2008/Upper-Deck-Ballpark-Collection---Base/42/Roy-Oswalt.jpg?id=3a821823-e003-4d54-b0f0-eb54de4175ee&size=original&side=front&.jpg
			https://img.comc.com/i/Baseball/2008/Upper-Deck-Ballpark-Collection---Base/42/Roy-Oswalt.jpg?id=3a821823-e003-4d54-b0f0-eb54de4175ee&size=original&side=back&.jpg

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
Line 50:		Line 53:
	</sql2wiki>		</sql2wiki>
	===Rookie Autographs===		===Rookie Autographs===

			https://img.comc.com/i/Baseball/2008/Upper-Deck-Ballpark-Collection---Base/116/Rookie-Autographs---Colt-Morton.jpg?id=45fe0bfb-729c-46e1-b47d-ca69ae27262a&size=original&side=front&.jpg
			https://img.comc.com/i/Baseball/2008/Upper-Deck-Ballpark-Collection---Base/116/Rookie-Autographs---Colt-Morton.jpg?id=45fe0bfb-729c-46e1-b47d-ca69ae27262a&size=original&side=back&.jpg

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
Line 55:		Line 61:
	</sql2wiki>		</sql2wiki>
	===Dual Swatch Memorabilia===		===Dual Swatch Memorabilia===

			https://img.comc.com/i/Baseball/2008/Upper-Deck-Ballpark-Collection---Base/157/Dual-Swatch-Memorabilia---Kenji-Johjima-Jason-Varitek.jpg?id=2c1f765b-f4b9-4e48-8d87-8f6c358cec6a&size=original&side=front&.jpg
			https://img.comc.com/i/Baseball/2008/Upper-Deck-Ballpark-Collection---Base/157/Dual-Swatch-Memorabilia---Kenji-Johjima-Jason-Varitek.jpg?id=2c1f765b-f4b9-4e48-8d87-8f6c358cec6a&size=original&side=back&.jpg

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
Line 60:		Line 69:
	</sql2wiki>		</sql2wiki>
	===Quad Swatch Memorabilia===		===Quad Swatch Memorabilia===

			https://img.comc.com/i/Baseball/2008/Upper-Deck-Ballpark-Collection---Base/217/Quad-Swatch-Memorabilia---Greg-Maddux-Mike-Mussina-Roy-Halladay-John-Smoltz.jpg?id=609d04bc-052f-4bda-9f70-d19ee05f4ac0&size=original&side=front&.jpg
			https://img.comc.com/i/Baseball/2008/Upper-Deck-Ballpark-Collection---Base/217/Quad-Swatch-Memorabilia---Greg-Maddux-Mike-Mussina-Roy-Halladay-John-Smoltz.jpg?id=609d04bc-052f-4bda-9f70-d19ee05f4ac0&size=original&side=back&.jpg

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
Line 65:		Line 77:
	</sql2wiki>		</sql2wiki>
	===Six Swatch Memorabilia===		===Six Swatch Memorabilia===

			https://img.comc.com/i/Baseball/2008/Upper-Deck-Ballpark-Collection---Six-Swatches-Memorabilia/WLRJHT/Kerry-Wood-Derrek-Lee-Aramis-Ramirez-Randy-Johnson-Dan-Haren-Chad-Tracy.jpg?id=006957dc-aeec-4e20-b709-b9c85201c522&size=original&side=front&.jpg
			https://img.comc.com/i/Baseball/2008/Upper-Deck-Ballpark-Collection---Six-Swatches-Memorabilia/WLRJHT/Kerry-Wood-Derrek-Lee-Aramis-Ramirez-Randy-Johnson-Dan-Haren-Chad-Tracy.jpg?id=006957dc-aeec-4e20-b709-b9c85201c522&size=original&side=back&.jpg

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
Line 70:		Line 85:
	</sql2wiki>		</sql2wiki>
	===Eight Swatch Memorabilia===		===Eight Swatch Memorabilia===

			https://img.comc.com/i/Baseball/2008/Upper-Deck-Ballpark-Collection---Eight-Swatch-Memorabilia/PCDMOZIR/Albert-Pujols-Chris-Carpenter-Chris-Duncan-Mark-Mulder-Magglio-Ordonez-Joel-Zumaya-Brandon-Inge-Ivan-Rodriguez.jpg?id=b067aab0-168d-4f37-8eb9-688661ae52c2&size=original&side=front&.jpg
			https://img.comc.com/i/Baseball/2008/Upper-Deck-Ballpark-Collection---Eight-Swatch-Memorabilia/PCDMOZIR/Albert-Pujols-Chris-Carpenter-Chris-Duncan-Mark-Mulder-Magglio-Ordonez-Joel-Zumaya-Brandon-Inge-Ivan-Rodriguez.jpg?id=b067aab0-168d-4f37-8eb9-688661ae52c2&size=original&side=back&.jpg

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
Line 77:		Line 95:

	===Jersey Buttons===		===Jersey Buttons===

			https://img.comc.com/i/Baseball/2008/Upper-Deck-Ballpark-Collection---Memorabilia---Jersey-Button/SA-57/Jeremy-Hermida.jpg?id=e4dc33a5-c999-4d7c-aa8b-b0c8f4fb338d&size=original&side=front&.jpg
			https://img.comc.com/i/Baseball/2008/Upper-Deck-Ballpark-Collection---Memorabilia---Jersey-Button/SA-57/Jeremy-Hermida.jpg?id=e4dc33a5-c999-4d7c-aa8b-b0c8f4fb338d&size=original&side=back&.jpg

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
Line 82:		Line 103:
	</sql2wiki>		</sql2wiki>
	===Jersey Laundry Tag===		===Jersey Laundry Tag===

			https://img.comc.com/i/Baseball/2008/Upper-Deck-Ballpark-Collection---Memorabilia---Laundry-Tag/SA-83/Matt-Cain.jpg?id=b783d40c-3f81-4b22-9b92-abd02ff37e83&size=original&side=front&.jpg
			https://img.comc.com/i/Baseball/2008/Upper-Deck-Ballpark-Collection---Memorabilia---Laundry-Tag/SA-83/Matt-Cain.jpg?id=b783d40c-3f81-4b22-9b92-abd02ff37e83&size=original&side=back&.jpg

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
Line 92:		Line 116:
	</sql2wiki>		</sql2wiki>
	===Jersey Autographs===		===Jersey Autographs===

			https://img.comc.com/i/Baseball/2008/Upper-Deck-Ballpark-Collection---Jersey--Auto/SA-52/Jeff-Francis.jpg?id=8356435f-6539-4d5c-8aa7-18dfc5a78248&size=original&side=front&.jpg
			https://img.comc.com/i/Baseball/2008/Upper-Deck-Ballpark-Collection---Jersey--Auto/SA-52/Jeff-Francis.jpg?id=8356435f-6539-4d5c-8aa7-18dfc5a78248&size=original&side=back&.jpg

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

Stalegum: /* Insertion Ratios */

2019-06-04T18:46:31Z

Insertion Ratios

← Older revision		Revision as of 14:46, 4 June 2019
Line 21:		Line 21:
	\|short set\|\|100\|\|-\|\|two-per-pack		\|short set\|\|100\|\|-\|\|two-per-pack
	\|-		\|-
	\|Rookie Autographs\|\|50\|\|-\|\|1:4		\|Rookie Autographs\|\|48\|\|-\|\|1:4
	\|-		\|-
	\|Dual Swatch Memorabilia\|\|50\|\|-\|\|one-per-pack		\|Dual Swatch Memorabilia\|\|47\|\|-\|\|one-per-pack
	\|-		\|-
	\|Quad Swatch Memorabilia\|\|50\|\|-\|\|one-per-pack		\|Quad Swatch Memorabilia\|\|44\|\|-\|\|one-per-pack
	\|-		\|-
	\|Six Swatch Memorabilia\|\|45\|\|-\|\|1:4		\|Six Swatch Memorabilia\|\|36\|\|-\|\|1:4
	\|-		\|-
	\|Eight Swatch memorabilia\|\|45\|\|-\|\|1:4		\|Eight Swatch memorabilia\|\|31\|\|-\|\|1:4
	\|-		\|-
	\|Jersey Buttons\|\|100\|\|varies\|\|?		\|Jersey Buttons\|\|100\|\|varies\|\|?

Stalegum: Created page with "=Description= 2008 Upper Deck Ballpark Collection was released September 17th, 2008. Each five-card pack will contain one Dual Swatch and one Quad Swatch Memorabilia card an..."

2019-06-04T18:00:31Z

Created page with "=Description= 2008 Upper Deck Ballpark Collection was released September 17th, 2008. Each five-card pack will contain one Dual Swatch and one Quad Swatch Memorabilia card an..."

New page

=Description=

2008 Upper Deck Ballpark Collection was released September 17th, 2008. Each five-card pack will contain one Dual Swatch and one Quad Swatch Memorabilia card and either a third game-used card or an autograph. Each four pack Hobby box will yield one Rookie Autograph, one Six Swatch and one Eight Swatch Memorabilia card, and one autographed memorabilia card.

=Distribution=

Four packs per box, five cards per pack (MSRP: $49.99). Hobby only.

=Reviews=

=Insertion Ratios=

{| class="ratio"
!Cards
!Total Cards
!Numbered To
!Hobby Odds
|-
|[[#Base_Set|Base]]||306||-||?
|-
|short set||100||-||two-per-pack
|-
|Rookie Autographs||50||-||1:4
|-
|Dual Swatch Memorabilia||50||-||one-per-pack
|-
|Quad Swatch Memorabilia||50||-||one-per-pack
|-
|Six Swatch Memorabilia||45||-||1:4
|-
|Eight Swatch memorabilia||45||-||1:4
|-
|Jersey Buttons||100||varies||?
|-
|Jersey Laundry Tag||100||varies||?
|-
|Jersey MLB Logo||100||varies||?
|-
|Jersey Autographs||100||-||1:4
|-
|Dual Memorabilia Autographs||7||-||?
|}

=Checklist=

==Base Set==

<sql2wiki database="carddb">
SELECT num,player,info,serial FROM cards WHERE (year = 2008) AND (setname LIKE 'Upper Deck Ballpark Collection') AND (num < 101);
</sql2wiki>
===Rookie Autographs===

<sql2wiki database="carddb">
SELECT num,player,info,serial FROM cards WHERE (year = 2008) AND (setname LIKE 'Upper Deck Ballpark Collection') AND (num BETWEEN 101 AND 150);
</sql2wiki>
===Dual Swatch Memorabilia===

<sql2wiki database="carddb">
SELECT num,player,info,serial FROM cards WHERE (year = 2008) AND (setname LIKE 'Upper Deck Ballpark Collection') AND (num BETWEEN 151 AND 200);
</sql2wiki>
===Quad Swatch Memorabilia===

<sql2wiki database="carddb">
SELECT num,player,info,serial FROM cards WHERE (year = 2008) AND (setname LIKE 'Upper Deck Ballpark Collection') AND (num BETWEEN 201 AND 250);
</sql2wiki>
===Six Swatch Memorabilia===

<sql2wiki database="carddb">
SELECT num,player,info,serial FROM cards WHERE (year = 2008) AND (setname LIKE 'Upper Deck Ballpark Collection') AND (num BETWEEN 251 AND 295);
</sql2wiki>
===Eight Swatch Memorabilia===

<sql2wiki database="carddb">
SELECT num,player,info,serial FROM cards WHERE (year = 2008) AND (setname LIKE 'Upper Deck Ballpark Collection') AND (num > 296);
</sql2wiki>
==Autographs & Game-Used==

===Jersey Buttons===

<sql2wiki database="carddb">
SELECT num,player,info,serial FROM cards WHERE (year = 2008) AND (setname LIKE 'Upper Deck Ballpark Collection Jersey Buttons');
</sql2wiki>
===Jersey Laundry Tag===

<sql2wiki database="carddb">
SELECT num,player,info,serial FROM cards WHERE (year = 2008) AND (setname LIKE 'Upper Deck Ballpark Collection Jersey Laundry Tag');
</sql2wiki>
===Jersey MLB Logo===

<sql2wiki database="carddb">
SELECT num,player,info,serial FROM cards WHERE (year = 2008) AND (setname LIKE 'Upper Deck Ballpark Collection Jersey MLB Logo');
</sql2wiki>
===Jersey Autographs===

<sql2wiki database="carddb">
SELECT num,player,info,serial FROM cards WHERE (year = 2008) AND (setname LIKE 'Upper Deck Ballpark Collection Jersey Autographs');
</sql2wiki>
===Dual Memorabilia Autographs===

<sql2wiki database="carddb">
SELECT num,player,info,serial FROM cards WHERE (year = 2008) AND (setname LIKE 'Upper Deck Ballpark Collection Dual Memorabilia Autographs');
</sql2wiki>
[[Category:Upper Deck]]
[[Category:2008]]