2017 Topps Sports Crate: Difference between revisions
| 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]] | ||
Revision as of 21:32, 10 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
June 2017
July 2017
August 2017
September 2017
