2017 Topps Sports Crate: Difference between revisions
| (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) | 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
- 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
- 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
- 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
- 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
- 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