SELECT distinct (b.attr1) as origAttr1, max(CASE WHEN b.attr1_alias IS NULL OR RTRIM(LTRIM(b.attr1_alias)) = '' THEN b.attr1 ELSE b.attr1_alias END) as attr1, max(a.sku_id) as sku_id, max(b.attr1_entry_id) as attr1_entry_id, sum(e.qoh+e.qc) as qoh, max(b.attr1_order) as sort_order, max(c.attr1_hex) as hex,max(d.attr1_fam) as fam,max(z.non_invt) as non_invt
FROM tb_skus a
LEFT JOIN tb_attr1_entries b WITH (NOLOCK) ON (b.attr1_entry_id = a.attr1_entry_id)
LEFT JOIN tb_sku_buckets e WITH (NOLOCK) ON (e.sku_id = a.sku_id)
LEFT JOIN tb_attr1_hexes c WITH (NOLOCK) ON (b.attr1=c.attr1)
LEFT JOIN tb_attr1_families d WITH (NOLOCK) ON (c.attr1_fam_id = d.attr1_fam_id)
LEFT JOIN tb_styles z on (z.style_id = a.style_id)
WHERE (a.sell_web not in ('N','NO') or (a.sell_web is null)) and a.style_id=?
AND e.store_id in(1,2,3)
GROUP BY b.attr1
ORDER BY max(b.attr1_order), max(b.attr1_entry_id)
Perhaps Panini America’s best brand and the world’s best top-flight soccerleague come together once again in 2020-21 Prizm Premier League Soccer. With all of the best players from all of the 2020-21 Premier League clubs showcased on Panini’s brilliant opti-chrome technology, these cards are not to be missed for the 2020-21 season!
A 300-card Base Set forms the foundation of the collection, featuring all 20 Premier League clubs and all of their stars. Watch out for three special Base Set Prizm parallels available only in Cereal Boxes: Blue Pulsar, Red Pulsar and Gold Pulsar!
Prizm Premier League offers a variety of inserts to collect! Fireworks and Scorers Club lead the group of inserts available in Cereal Boxes that highlight highly collectible footballers.
Prizm Premier League will once again be the home of Panini’s soccer Kaboom! cards for 2020-21. These colorful illustrations of only the very best players are one-of-a-kind collectibles!
· 25 CARDS PER PACK
2020-2021 Premier League Soccer Trading Cards 25 cards in the box. 3 exclusive blue, Red or Pink Pulsar Prizes per box on AVERAGE.