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 SG Extra Finger Support is made for superior goalkeeping performances. 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. The SG Soft Grip palm foam with reliable grip and damping qualities is especially suited for beginners and comes with a soft and smooth surface for great goalkeeping performance on natural grass. The DuraGuard™ latex patch offers extra abrasion resistance and durability in the most stressed zone of the palm. 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.