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 West Germany defeated Argentina to complete a hat trick of world titles, they did it in a kit that has since enjoyed the same legendary status as the country's 1990 heroes. Taking inspiration from that design classic, this men's football jersey is a replica of the home shirt Germany's current stars wear. It's made of sweat-sweeping Climalite, with a slightly looser cut and a woven national badge on the chest. adidas is dedicated to creating products in ways that minimise their environmental impact. This jersey is made with recycled polyester to save resources and decrease emissions."
A replica jersey is inspired by what players wear and features a woven crest
Ribbed crewneck with tipping detail; Germany home graphic on the inside back collar
Woven Germany crest and FIFA World Champions crest on chest
Heat-transfer "Die Mannschaft" below back collar
3-Stripes on shoulders; Woven adidas Badge of Sport on chest