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,4)
GROUP BY b.attr1
ORDER BY max(b.attr1_order), max(b.attr1_entry_id)
LATEX- 4mm Turf Approved Fluro German All Weather Supreme Grip
WRIST- Double Elastic Wrist Strap
BACKHAND - Ultra Durable Composite
FIT - Medium to Precise Fitting Glove
Brand new from the Ground up, the all New Laguna Series is here LAGUNA STRIKE. We completely redesigned the Laguna: 1. Lighter 2. More Flexible 3. Punch Zone 4. Anti-Slip Internal Grip 5. Side Surround Cut 6. Wrap Over Fingertips 7. 3D Honeycomb Mesh -
Weather: All Weather Glove, Peel the plastic off, for an even better grip wash and dry prior to use! Made for Rain or Shine, any condition- with 3D honeycomb mesh to help with preventing your hand from getting to hot!
Grip: This latex is super sticky 4mm 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 works best when slightly dampened. (the chemicals in the latex are activated). It does also get better as you break it in, and wear it!
CUT: A form fitting Hybrid Cut, we use a Gun/Roll/Flat Combo to provide a great fit and feel. The glove contours the hand, without being too bulk as well as not being to small at the same time!
Wrist: Double Elastic Wrist Entry with our Brand new Ultra Wear Velcro, built to last longer and not wear out! Glove ID Box with a spot to get your name/number or favorite thing ID'd for just $9.
Backhand: 3mm Composite water resistant backhand with ergonomically designed break points along the backhand provide maximum flexibility, while keeping the hands in a natural position when flexing and catching. We have also added our signature Memory Foam lining to the backhand- it makes the glove more comfortable, but also helps in greatly reducing the shock on the hands when you catch!