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
HAVING sum(e.qoh+e.qc) > 0
ORDER BY max(b.attr1_order), max(b.attr1_entry_id)
"Catch or punch, you block the shot. This men's football goalkeeper jersey offers unrestricted movement to help you make that crucial save. Tight sleeves stay in place as you reach and move for the ball, while a goalkeeper-specific design keeps the shirt from riding up as you extend your arms to claim the ball. It's made of sweat-sweeping Climalite to keep you dry.
adidas is committed to creating products in more sustainable ways. This jersey is made with recycled polyester to save resources and decrease emissions."
Extra fabric under sleeves helps prevent jersey from riding up when arms are extended over head
Sleeve length designed to end where goalkeeper gloves begin; Tight fit at bottom of sleeves to keep jersey in place on arms
Super-stretchy fabric for excellent freedom of movement in goalie-critical areas
Bold graphic helps goalkeeper stands out on the field of play