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
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)
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
HAVING sum(e.qoh+e.qc) > 0
ORDER BY max(b.attr1_order), max(b.attr1_entry_id)
Revolutionary hybrid of a roll finger cut and our Rolled Expanse Cut . Includes our new Evolution ESS Cut , (Ergonomic Support System) that uses a pattern that helps the fingers to be pre-splayed. Our 3D Thumb Crotch is one of our latest inventions. Backhand of Glove: Super Softi foam. Embossed foam design makes the glove more flexible at many breakpoints. Full Strap Wrist Bandage closure. Mesh gussets for breathability. These Reusch Finger Support stays are flexible finger protectors that run up the fingers and the thumb, reducing the chance for injury. These Reusch Finger Support stays are flexible finger protectors that run up the fingers and the thumb, reducing the chance for injury. Our AirVentSystem uses highly breathable Air Mesh material to make this glove more comfortable. Side mesh vents allow this glove to keep cooler during match play. Our Keep Control helps when catching and holding the ball. The inside of the small finger is covered with a highly functioning latex palm material.