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)
Competitive glove with durable grip for training and matches, the Threat features abrasion-resistant Quartz German latex. It features 3.5mm of German latex with an extended palm for extra grip.
Quartz German Giga latex (3.5mm + 3mm impact foam) with textured speckles for extra grip in games and practices. Includes an extended grippy palm that covers the wrist for extra grip.
"Negative" cut (hidden gussets) provides a snug natural fit; includes roll-thumbs (extra latex wrapping around the thumbs). Full wrist wrap for extra comfort and security.
Includes removable finger spines to reduce risk of injuries and enable customization.
Everzone fabric body, breathable and light, ideal for both warm and cool weather.
Breathable glove bag included so you can carry them around and keep them fresh.