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)
Be the One – the Reusch Attrakt RG Open Cuff Finger Support Junior is the perfect choice for young goalkeepers ready to step up their game. Trusted by more than 220 first-league goalkeepers all over the world, such as the top stars Hugo Lloris, Wojciech Szczesny, Samir Handanovic, Jirí Pavlenka or Agustín Marchesín, Reusch is among the worldwide leading glove specialists. As part of the Solid Series, these gloves have been especially engineered for best performance on hard grounds and artificial grass. Characterized by very good abrasion resistance and damping properties thanks to its structured and sturdy surface, the RG Resist Grip has been especially engineered for goalkeeping on synthetic grounds. The high-quality Finger Support™ finger protection system reduces the risk of injury – with the sticks adapting the shape of the fingers, the hand can grasp flexibly without restrictions, whereas bending the fingers backward into the injury zone is close to impossible.