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)
The most protective 5-star ASTM-certified headgear in soccer, our ExoShield Head Guard is the only product shown to statistically reduce the risk of head injuries in a recent multi-year independent study.*
According to the Virginia Tech Helmet Lab, this protective headgear lowers the rate of head injuries by as much as 84%. Provides comfort and safety for players of all ages and backgrounds.
Protects thousands of players from cuts, bruises and contusions with its 8oz ultra-light, minimalist design that conforms to the head without affecting style of play and accommodating all hairstyles comfortably.
The ExoShield is powered by 9-12mm of Team Wendy Zorbium® foam, the same military-grade lining used in the helmets of US Army, Navy and Special Forces.
The official headgear of US Club Soccer
Learn moreabout team order options (see bottom option).
Compliant with ASTM, NFHS and FIFA Rule-4 standards
Foam is engineered specially for soccer to reduce g-forces to the head by up to 50%
Team Wendy® Zorbium® Foam armors the helmets of the U.S. Army, Navy and Marine Corps
Awarded top rank from Virginia Tech's Helmet Lab with an estimated 84% reduction in risk of head injuries
In a 2-year field study funded by NOCSAE and run by University of Wisconsin Madison with ~3,000 high school soccer players, the Storelli's ExoShield Head Guard reduced the relative risk of concussions by ~50% overall and 60% in females specifically