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)
"Three decades. That's how long Argentina's fans had waited for their team to claim South America's biggest prize. So when la Selección became continental champions in 1991, the kit they did it in became instantly iconic.
Inspired by that memorable strip, this men's football jersey is a replica of the official jersey Argentina will wear as they take on the world this summer in Russia. It has a slightly looser cut and sweat-wicking Climalite for fan comfort and displays a woven Argentina badge."
A replica jersey is inspired by what players wear and features a woven crest
Ribbed V-neck; Back neck tape
Moisture-wicking stripes on front and back panels
Argentina woven crest on chest; Embossed "125" emblem on side
3-Stripes on shoulders; Woven adidas Badge of Sport on chest