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)
"Feared by rivals and treasured by the home support. The Allianz Arena has served as the backdrop to some of the greatest moments in football. This jersey is inspired by the diamond facade of FC Bayern's fortress. Built to keep fans in the comfort zone, it has a slightly looser cut than the ones the players wear on match days. It's made from silky fabric that wicks away sweat from your skin.
Made for fans
A fan jersey is a streetwear version of what players wear on match days that is wider in the shoulders and body
Climalite wicks sweat to keep you dry in every condition"
Mesh inserts on sides and inner sleeves; Sweat-wicking Climalite fabric
FC Bayern woven crest
This jersey is made with recycled polyester to save resources and decrease emissions