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)
The Pro is the top-selling glove in our Gladiator line.
The Pro is a favorite of competitive keepers who like heavy-duty soccer gloves with the best grip on the market. These goalie gloves feature a reinforced backhand with a textured punch zone, top-grade embossed German latex on the palm, negative cut, removable finger protection (5 spines, including thumb) and premium breathable glove bag.
Version 3.0 is virtually identical to its predecessor v2.0, with one major improvement: the latex. We upgraded it to the latest unaltered German Contact foam, which comes protected in plastic so it's at its purest and tackiest once you open it.
Designed for competitive goalkeepers who demand heavy-duty impact protection and grip.
Features the highest grade German latex that delivers the grip used by world-class professionals. 3mm of impact foam to afford maximum palm protection + 3.5mm German latex.
Negative cut with roll-thumbs (extra latex wrapping around the thumbs for extra grip) and embossed palm for enhanced flexibility. Full wrist wrap for extra comfort and security.
Includes removable finger spines to reduce risk of injuries and enable customization.
Textured polybutylene punch zones for extra control and security.