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)
A Professional match glove.The 4mm Elite Grip Latex palm provides excellent grip and shock absorption in all weather conditions. Based on the Xtreme Grip, this palm represents PUMAs latest development step in keeping the positive characteristics of thispalm and improving its durability.Whilst the hybrid cut of gun cut on the index and little finger combined with regular cut on the middle two fingers, and the twin wrap on the thumb, provides additional grip on the fingers which are most in contact with the ball as well as the comfort provided by a rollfinger glove.The unique biomimic segmented backhand provides a superb and secure fit , and removes the need for a tradtional wrist bandage.Mesh finger gussets provide breathability making it a perfect glove for the summer which performs fantastically in the all weather conditions