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
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)
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)
"The football fashion subculture first emerged in the UK in the 1980s. Thanks to their club's regular journeys across Europe, Manchester United supporters were there at the start. This season, the club's home kit pays tribute to its fans' role in creating a new trend.
This men's short sleeve jersey is a version of the home shirt the current Red Devils squad wears. It features a henley collar with a button placket, contrast flat-knit cuffs and a woven club badge on the chest."
A version of the home jersey Man Utd wear.
Ventilated climacool® keeps you cool and dry
Henley collar with button placket
Mesh inserts on sides and sleeves; Contrast flat-knit cuffs
3-Stripes on shoulders; adidas Badge of Sport woven on right chest
Manchester United woven crest on left chest
This product is part of the adidas sustainable product program: Products are made in more sustainable ways to make the world a better place; Every fibre counts: Recycled polyester saves resources and decreases emissions