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,4)
GROUP BY b.attr1
ORDER BY max(b.attr1_order), max(b.attr1_entry_id)
A top level competition glove with our 4mm Ultimate Grip Latex palm which provides unrivalled grip in both wet and dry conditions.Featuring our Puma patented Flextec 2 finger protection , which protects fingers from hyperextension by locking at 180 degrees , and Puma patented thumb spine protection , all of which are lightweight and removable.This allows the goalkeeper to customise the protection of their glove to their specific needs.The twin wrap thumb maximises latex to ball contact, and the anatomically spread tooling follows the hands natural shape and contour for total comfort. A embossed silicon punching zone provides enhanced protection , whilst the embossed latex backhand with neoprene body offer's futher comfort and a close fit .Breathability throughout the glove is provided by mesh inserts on the thumb and backhand , and mesh finger gussets. A full length latex wrist strap provides wrist support and a secure closure.