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)
Our German made and engineered G3 Ultrasoft foam outranks its forerunner in terms of grip in dry and wet conditions. This NEW foam also improves the abrasion resistance; the addition of various components makes this palm material noticeably stronger. Best cushioning when stopping very hard and fast balls. The backhand base of flexible and breathable mesh material is rolled to the palm which supports an ergonomic fit and increases wearing comfort. This is great game foam as it has terrific stopping and gripping properties. Our 3D Thumb Crotch™ is one of our latest inventions. This rolled crotch construction between the thumb and the index finger eliminates any seams that can bother the keeper in an area that takes a lot of stress. The backhand base of the flexible and breathable mesh material is rolled to the palm which supports an ergonomic fit and increases wearing comfort.
BACKHAND OF GLOVE:
Super Softi foam all over. Embossed foam design makes the glove more flexible at many breakpoints. The new Wider Wrist Bandage gives the keeper a better fit and more control.
Our Surround Cut™ with negativeseams. This special cut allows 100% of our G3 Ultrasoft foam on all points of contact for a maximum grip and control of the ball. 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. Includes Thumbflex™ and our Pull Loop™ system. This Pull Loop™ system helps the keeper get their gloves on, especially when one glove is already on. Full wrist strap with textile window.