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)
Grip, agility, lightness, breathability: Dominate the game with the all new Pure Contact 3 goalkeeper gloves!
Designed as a complete one-piece construction, the highly flexible FreeFlex™ backhand turns the Pure Contact into our lightest professional glove ever, simply fitting like a second skin. The S1 Super Soft is one of our softest palm foams, delivering very good results in terms of grip and cushioning as well as reliable abrasion resistance when used on natural grass. The expansion of the palm foam all the way to the cuff significantly enlarges the latex-to-ball contact zone for optimized grip. Thanks the well-known Asymmetric Slip-On Cuff with integrated strap the Pure Contact offers individual fixation and a super stable hold around the wrist. The glove now features 100% internal seams, a wrapped thumb as well as an extension of the palm towards the backhand on the pinky finger side, in order to create the tightest and most direct fit possible.