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 S1 Super Soft Grip foam is a high quality palm made of natural latex that is best suited for natural grass fields. This S1 foam is our Super Thick Foam (STF) is 4mm thick. This thicker foam gives the keeper more cushion when stopping the ball and also offers a longer lasting palm.
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, reducing the chance for injury.
Construction: The optimal fit and catching zone provided by our revolutionary Expanse Cut ESS (Ergonomic Support System) uses a pattern that helps the fingers to be pre-splayed (spread so the keeper has a better hand position on the ball). 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. The deep thumb notch on the face of the glove includes an elasticized piece below the foam to help eliminate tear out. We also use an elasticized thread throughout the glove to help eliminate tear out. Side mesh vents allow this glove to keep cooler during match play. Includes Thumbflex.