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)
Palm of Glove: Our German made and engineered SG Soft Grip foam is a quality palm made of a natural and synthetic latex mixture.
Backhand of Glove: Softer PVC backing. Embossed foam design makes the glove more flexible at many breakpoints. Full Strap Wrist Bandage closure. Mesh gussets for breathability.
Construction: Expanse Cut. This new model offers protection for the fingers and the thumb with sewn in stays. These Reusch Finger Support stays are flexible finger protectors that run up the fingers and the thumb, reducing the chance for injury. This new cut has a deeper thumb notch on the face of the glove that includes an elasticized piece below the foam to help eliminate tear out. Spread fingers, mesh gussets Thumbflex.