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)
"When Man Utd won the national knockout competition for the first time in club history, the team wore a Lancashire rose on their crest. A tribute to the 1909 legends, this alternate jersey displays a glitched graphic of that enduring symbol of the county. Built to keep fans comfortable, it has a slightly looser cut than the ones athletes wear on match days. It's made from silky fabric that wicks away sweat from your skin.
Celebrating 110 years since the club's historic victory, the jersey features a 1909 2019 sign-off on the front side as well as embroidered details on the woven club crest
Made for fans
A fan jersey is a streetwear version of what players wear on match days and is wider in the shoulders and body
Climalite wicks sweat to keep you dry in every condition"
Manchester United woven crest
Sweat-wicking Climalite fabric; Treble Winners graphic above hem
This jersey is made with recycled polyester to save resources and decrease emissions