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
ORDER BY max(b.attr1_order), max(b.attr1_entry_id)
LATEX- 4mm Pro Black German Supreme All Weather Palm
WRIST- Latex Wide Single Wrist Strap
BACKHAND - Ultra Durable Composite
FIT - Medium to Larger Fitting Glove
Weather: This All-Weather German Supreme Latex offers incredible durability and provides a great glove in most any condition, peel the plastic and play or give a pre-wash for an even better grip!
Grip: This latex is super sticky 4mm Black German Supreme Latex is one of the top Latex's used in the world, it will provide amazing grip and provide great feel for the ball. It is highly recommended to Pre-wet for best grip possible, wetting the Supreme Latex will activate the chemicals in the Latex as well as decrease the wear on the glove.
CUT: BioHYBRID- This Cut Combines Wrap Over/Under Thumb for light feel and increased flexibility along with a Roll Index (with V notch for improved flexibility) and pinky, with a MAX Middle and Ring Finger. The Combination of Cuts was developed over 18 months with over half of the West Coast Pro-Team Keepers testing and providing feedback. The cut is designed is designed to contour to your hand with a enhanced pre-curve, making this the first cut of its type from a North American Glove Company!
Wrist: Latex Wrist strap with double Velcro for added security provide a snug and close fitting enclosure along with an extra large Glove iD box.
Backhand: 3mm Composite German Latex with Four Flexibility points in the backhand to allow full motion of the hand, along with a thin lining of Comfort Foam to give the maximum amount of comfort in any glove. STRIKE GUARD punching zone was designed by capturing Slo-Mo video footage of Keepers to examine exactly where Punching Support was needed, we then placed the STRIKE GUARD punching zone in the exact location where over 95% of keepers punch