1993 Upper Deck Diamond Gallery - Revision history

Stalegum: /* Checklist */

2023-03-15T20:06:53Z

Checklist

@@ Line 17: / Line 17: @@
 <sql2wiki database="carddb">
-SELECT num,player,info FROM cards WHERE (year = 1993) AND (setname = 'Upper Deck Diamond Gallery') AND (num < 29);
+SELECT num,player,info FROM cards WHERE (year = 1993) AND (setname = 'Upper Deck Diamond Gallery') AND (num < 29) AND (num REGEXP ('^[0-9]+$'));
 </sql2wiki>
 ===Gallery of Heroes===
@@ Line 82: / Line 25: @@
 <sql2wiki database="carddb">
-SELECT num,player,info FROM cards WHERE (year = 1993) AND (setname = 'Upper Deck Diamond Gallery') AND (num BETWEEN 29 AND 31);
+SELECT num,player FROM cards WHERE (year = 1993) AND (setname = 'Upper Deck Diamond Gallery') AND (num BETWEEN 29 AND 31);
 </sql2wiki>
 ===Diamonds in the Rough===
@@ Line 97: / Line 33: @@
 <sql2wiki database="carddb">
-SELECT num,player,info FROM cards WHERE (year = 1993) AND (setname = 'Upper Deck Diamond Gallery') AND (num > 31);
+SELECT num,player FROM cards WHERE (year = 1993) AND (setname = 'Upper Deck Diamond Gallery') AND (num > 31);
 </sql2wiki>
 https://img.comc.com/i/Baseball/1993/Upper-Deck-Diamond-Gallery---Base/CHEC/Checklist.jpg?id=5758e1fb-c18c-40b0-83d8-3f2ea3b79121&size=original&side=front&.jpg
@@ Line 117: / Line 43: @@
 Each sealed boxed set contained a (non-holographic) checklist card that is serial-numbered to 123,600 sets and a coupon good for a custom 36-card album.  The album coupon expired June 30th, 1994.
-NNO Checklist
+<sql2wiki database="carddb">
+SELECT player FROM cards WHERE (year = 1993) AND (setname = 'Upper Deck Diamond Gallery') AND (num = 'NNO');
-NNO Album Offer
+</sql2wiki>
 [[Category:Upper Deck]]
 [[Category:1993]]
 [[Category:Boxed Sets]]

Stalegum: /* Checklist */

2022-03-07T15:34:37Z

Checklist

← Older revision		Revision as of 11:34, 7 March 2022
Line 13:		Line 13:
	=Checklist=		=Checklist=

	==Base ~~Set~~==		https://img.comc.com/i/Baseball/1993/Upper-Deck-Diamond-Gallery---Base/4/Roberto-Alomar.jpg?id=46822490-1231-4ecf-92b0-a3ccc80c0965&size=original&side=front&.jpg
			https://img.comc.com/i/Baseball/1993/Upper-Deck-Diamond-Gallery---Base/4/Roberto-Alomar.jpg?id=46822490-1231-4ecf-92b0-a3ccc80c0965&size=original&side=back&.jpg

	<sql2wiki database="carddb">		<sql2wiki database="carddb">
	SELECT ~~DISTINCT setname~~ FROM cards WHERE (year = 1993) AND (setname ~~LIKE~~ 'Upper Deck %');		SELECT num,player,info FROM cards WHERE (year = 1993) AND (setname = 'Upper Deck Diamond Gallery') AND (num < 29);
	</sql2wiki>		</sql2wiki>

Line 74:		Line 75:

	28 Don Mattingly		28 Don Mattingly

			===Gallery of Heroes===

			https://img.comc.com/i/Baseball/1993/Upper-Deck-Diamond-Gallery---Base/31/Ozzie-Smith.jpg?id=3b9a8fc0-8740-40a9-a1f7-bf9675336d8b&size=original&side=front&.jpg
			https://img.comc.com/i/Baseball/1993/Upper-Deck-Diamond-Gallery---Base/31/Ozzie-Smith.jpg?id=3b9a8fc0-8740-40a9-a1f7-bf9675336d8b&size=original&side=back&.jpg

			<sql2wiki database="carddb">
			SELECT num,player,info FROM cards WHERE (year = 1993) AND (setname = 'Upper Deck Diamond Gallery') AND (num BETWEEN 29 AND 31);
			</sql2wiki>

	29 Rickey Henderson		29 Rickey Henderson
Line 80:		Line 90:

	31 Ozzie Smith		31 Ozzie Smith

			===Diamonds in the Rough===

			https://img.comc.com/i/Baseball/1993/Upper-Deck-Diamond-Gallery---Base/34/Mike-Piazza.jpg?id=3320b514-842b-4288-ae37-34c18aa57870&size=original&side=front&.jpg
			https://img.comc.com/i/Baseball/1993/Upper-Deck-Diamond-Gallery---Base/34/Mike-Piazza.jpg?id=3320b514-842b-4288-ae37-34c18aa57870&size=original&side=back&.jpg

			<sql2wiki database="carddb">
			SELECT num,player,info FROM cards WHERE (year = 1993) AND (setname = 'Upper Deck Diamond Gallery') AND (num > 31);
			</sql2wiki>

	32 Wil Cordero		32 Wil Cordero
Line 91:		Line 110:
	36 Kevin Young		36 Kevin Young

	NNO Checklist ~~Card~~		https://img.comc.com/i/Baseball/1993/Upper-Deck-Diamond-Gallery---Base/CHEC/Checklist.jpg?id=5758e1fb-c18c-40b0-83d8-3f2ea3b79121&size=original&side=front&.jpg
			https://img.comc.com/i/Baseball/1993/Upper-Deck-Diamond-Gallery---Base/CHEC/Checklist.jpg?id=5758e1fb-c18c-40b0-83d8-3f2ea3b79121&size=original&side=back&.jpg<br />
			https://img.comc.com/i/Baseball/1993/Upper-Deck-Diamond-Gallery---Base/ALOF/Album-Offer.jpg?id=78fa10ca-330e-42dd-96b6-9c81887cac4b&size=original&side=front&.jpg
			https://img.comc.com/i/Baseball/1993/Upper-Deck-Diamond-Gallery---Base/ALOF/Album-Offer.jpg?id=78fa10ca-330e-42dd-96b6-9c81887cac4b&size=original&side=back&.jpg

			Each sealed boxed set contained a (non-holographic) checklist card that is serial-numbered to 123,600 sets and a coupon good for a custom 36-card album. The album coupon expired June 30th, 1994.

			NNO Checklist

	NNO Album Offer ~~Card~~		NNO Album Offer

	[[Category:Upper Deck]]		[[Category:Upper Deck]]
	[[Category:1993]]		[[Category:1993]]
			[[Category:Boxed Sets]]

Stalegum: /* Checklist */

2022-03-07T15:26:36Z

Checklist

← Older revision		Revision as of 11:26, 7 March 2022
Line 14:		Line 14:

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

			<sql2wiki database="carddb">
			SELECT DISTINCT setname FROM cards WHERE (year = 1993) AND (setname LIKE 'Upper Deck %');
			</sql2wiki>

	1 Tim Salmon		1 Tim Salmon

Stalegum: Created page with ' =Description= 1993 Upper Deck Diamond Gallery is a 36-card, all-hologram, boxed set. Two subsets are pres…'

2011-03-04T06:33:08Z

Created page with ' =Description= 1993 Upper Deck Diamond Gallery is a 36-card, all-hologram, boxed set. Two subsets are pres…'

New page

=Description=

1993 Upper Deck Diamond Gallery is a 36-card, all-hologram, boxed set. Two subsets are present in this set; cards 29-31 are Gallery Heroes subset, and cards 32-36 are Diamonds in the Rough. Also included in the set are the checklist bearing the production number out of 123,600 sets produced, and a mail-away card for the Diamond Gallery card album.

=Distribution=

Boxed set

=Reviews=

=Checklist=

==Base Set==

1 Tim Salmon

2 Jeff Bagwell

3 Mark McGwire

4 Roberto Alomar

5 Terry Pendleton

6 Robin Yount

7 Ray Lankford

8 Ryne Sandberg

9 Darryl Strawberry

10 Marquis Grissom

11 Barry Bonds

12 Carlos Baerga

13 Ken Griffey Jr.

14 Benito Santiago

15 Dwight Gooden

16 Cal Ripken

17 Tony Gwynn

18 Dave Hollins

19 Andy Van Slyke

20 Juan Gonzalez

21 Roger Clemens

22 Barry Larkin

23 David Nied

24 George Brett

25 Travis Fryman

26 Kirby Puckett

27 Frank Thomas

28 Don Mattingly

29 Rickey Henderson

30 Nolan Ryan

31 Ozzie Smith

32 Wil Cordero

33 Phil Hiatt

34 Mike Piazza

35 J.T. Snow

36 Kevin Young

NNO Checklist Card

NNO Album Offer Card

[[Category:Upper Deck]]
[[Category:1993]]