Difference between revisions of "2017 Topps Sports Crate"

From BaseballCardPedia.com
Jump to: navigation, search
(Description)
(Checklist)
 
(One intermediate revision by the same user not shown)
Line 15: Line 15:
  
 
<sql2wiki database="carddb">
 
<sql2wiki database="carddb">
SELECT player,team FROM cards WHERE (year = 2017) AND (setname = 'Topps Sports Crate) AND (num < 11)
+
SELECT num,player,team FROM cards WHERE (year = 2017) AND (setname = 'Topps Sports Crate') and (num < 11)
 
</sql2wiki>
 
</sql2wiki>
 
==June 2017==
 
==June 2017==
Line 23: Line 23:
  
 
<sql2wiki database="carddb">
 
<sql2wiki database="carddb">
SELECT player,team FROM cards WHERE (year = 2017) AND (setname = 'Topps Sports Crate) AND (num BETWEEN 11 AND 20)
+
SELECT num,player,team FROM cards WHERE (year = 2017) AND (setname = 'Topps Sports Crate') AND (num BETWEEN 11 AND 20)
 
</sql2wiki>
 
</sql2wiki>
 
==July 2017==
 
==July 2017==
Line 31: Line 31:
  
 
<sql2wiki database="carddb">
 
<sql2wiki database="carddb">
SELECT player,team FROM cards WHERE (year = 2017) AND (setname = 'Topps Sports Crate) AND (num BETWEEN 21 AND 30)
+
SELECT num,player,team FROM cards WHERE (year = 2017) AND (setname = 'Topps Sports Crate') AND (num BETWEEN 21 AND 30)
 
</sql2wiki>
 
</sql2wiki>
 
==August 2017==
 
==August 2017==
Line 39: Line 39:
  
 
<sql2wiki database="carddb">
 
<sql2wiki database="carddb">
SELECT player,team FROM cards WHERE (year = 2017) AND (setname = 'Topps Sports Crate) AND (num BETWEEN 31 AND 40)
+
SELECT num,player,team FROM cards WHERE (year = 2017) AND (setname = 'Topps Sports Crate') AND (num BETWEEN 31 AND 40)
 
</sql2wiki>
 
</sql2wiki>
 
==September 2017==
 
==September 2017==
Line 47: Line 47:
  
 
<sql2wiki database="carddb">
 
<sql2wiki database="carddb">
SELECT player,team FROM cards WHERE (year = 2017) AND (setname = 'Topps Sports Crate) AND (num > 40)
+
SELECT num,player,team FROM cards WHERE (year = 2017) AND (setname = 'Topps Sports Crate') AND (num > 40)
 
</sql2wiki>
 
</sql2wiki>
 
[[Category:Topps]]
 
[[Category:Topps]]
 
[[Category:2017]]
 
[[Category:2017]]

Latest revision as of 15:33, 13 January 2020

Description

2017 Topps Sports Crate is a 50-card set distributed exclusively through the Sports Crate subscription program. Beginning in May and continuing for the next five months, a new Sports Crate for each of ten teams (Red Sox, Cubs, Tigers, Royals, Dodgers, Mets, Yankees, Giants, Cardinals, and Rangers) was available. Individual crates, which included clothing, collectibles, and other novelties, along with the exclusive Topps card, would cost $39.99, with an annual team subscription for $179.99.

Distribution

Reviews

Checklist

May 2017

May---Danny-Duffy.jpg?id=251b4e7c-9240-4872-92fa-bff279e11bef&size=original&side=front&.jpg May---Danny-Duffy.jpg?id=251b4e7c-9240-4872-92fa-bff279e11bef&size=original&side=back&.jpg

  • 1 Noah Syndergaard Mets
  • 2 Cole Hamels Rangers
  • 3 Danny Duffy Royals
  • 4 Justin Verlander Tigers
  • 5 Madison Bumgarner Giants
  • 6 Adam Wainwright Cardinals
  • 7 Rick Poello Red Sox
  • 8 Jon Lester Cubs
  • 9 Clayton Kershaw Dodgers
  • 10 Masahiro Tanaka Yankees

June 2017

June---Salvador-Perez.jpg?id=4811a521-f446-43dc-a4ea-bea66d37ba18&size=original&side=front&.jpg June---Salvador-Perez.jpg?id=4811a521-f446-43dc-a4ea-bea66d37ba18&size=original&side=back&.jpg

  • 11 Travis d'Arnaud Mets
  • 12 Jonathan Lucroy Rangers
  • 13 Salvador Perez Royals
  • 14 James McCann Tigers
  • 15 Buster Posey Giants
  • 16 Yadier Molina Cardinals
  • 17 Sandy Leon Red Sox
  • 18 Miguel Montero Cubs
  • 19 Yasmani Grandal Dodgers
  • 20 Gary Sanchez Yankees

July 2017

July---Didi-Gregorius.jpg?id=033b1ba7-d449-47a1-9b3e-48ebb5b28dca&size=original&side=front&.jpg July---Didi-Gregorius.jpg?id=033b1ba7-d449-47a1-9b3e-48ebb5b28dca&size=original&side=back&.jpg

  • 21 Yoenis Cespedes Mets
  • 22 Adrian Beltre Rangers
  • 23 Eric Hosmer Royals
  • 24 Miguel Cabrera Tigers
  • 25 Brandon Crawford Giants
  • 26 Matt Carpenter Cardinals
  • 27 Mookie Betts Red Sox
  • 28 Kris Bryant Cubs
  • 29 Corey Seager Dodgers
  • 30 Didi Gregorius Yankees

August 2017

August---Hunter-Pence.jpg?id=6cff241d-96b8-4e09-be32-b0fe991a403c&size=original&side=front&.jpg August---Hunter-Pence.jpg?id=6cff241d-96b8-4e09-be32-b0fe991a403c&size=original&side=back&.jpg

  • 31 David Wright Mets
  • 32 Elvis Andrus Rangers
  • 33 Alex Gordon Royals
  • 34 Nick Castellanos Tigers
  • 35 Hunter Pence Giants
  • 36 Dexter Fowler Cardinals
  • 37 Dustin Pedroia Red Sox
  • 38 Anthony Rizzo Cubs
  • 39 Adrian Gonzalez Dodgers
  • 40 CC Sabathia Yankees

September 2017

September---Johnny-Cueto.jpg?id=ead826e0-324d-4f6a-9211-834674063d28&size=original&side=front&.jpg September---Johnny-Cueto.jpg?id=ead826e0-324d-4f6a-9211-834674063d28&size=original&side=back&.jpg

  • 41 Jacob deGrom Mets
  • 42 Rougned Odor Rangers
  • 43 Lorenzo Cain Royals
  • 44 Ian Kinsler Tigers
  • 45 Johnny Cueto Giants
  • 46 Stephen Piscotty Cardinals
  • 47 Andrew Benintendi Red Sox
  • 48 Javier Baez Cubs
  • 49 Joc Pederson Dodgers
  • 50 Aaron Judge Yankees