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)
Panini are excited to announce the launch of our Road to FIFA World Cup Qatar 2022 Sticker Collection! The road to the FIFA World Cup starts here! Join the journey to Qatar with our exclusive new and official sticker collection, which covers 40 of the nation’s looking to book their ticket to the FIFA World Cup Qatar 2022!! Collectors can get stuck in and collect all 40 teams featured in the collection, each of them featuring 15 different players. Is there a better way to get into the spirit of the FIFA World Cup Football’s biggest prize is coming in 2022 and collectors and fans alike can get ready with this awesome new preview collection! Look for All the Top Soccer Superstars from around the World including Lionel Messi, Cristiano Ronaldo, Neymar Jr, Erling Haaland, Christian Pulisic, Kylian Mbappe, Jadon Sancho, Mohamad Salah, Harry Kane, Robert Lewandowski, Eden Hazard, Luis Suarez, Luka Modric, Arjen Robben, Mannuel Neuer, Rodrygo & Many, Many More!