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)
"A creation. Born on a canvas. Now, ready for action. Wherever you are. This Germany home jersey is ideal for a streetwear look with its relaxed fit. It is a casual version of what the players wear on match days. The embroidered crest on the chest proudly details four stars, each one signalling a successful World Cup campaign. ?
Stripes as an essential design element have been part of the team's jersey history. In this new design the hand-painted pinstripes and sleeve details are a statement for an open and modern nation. The dynamic tri-colour effect on the cuffs stands for the diversity in Germany and the different origins of players and fans. Show your support for ""Die Mannschaft"" with this authentic jersey.?"
Mesh inserts on sides
Germany woven crest
Star graphic below back collar
This jersey is made with recycled polyester to save resources and decrease emissions