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)
Breathable goalkeeper jersey armored with ergonomic XRD® Extreme Impact Protection on the elbows and slim fit construction to hold up comfortably in any condition.
DETAILS
Engineered to shut down distractions and prevent bruises and contusions, even when you make that upper corner save.
Armored with XRD® Extreme Impact Protection ergonomic elbow pads that absorb up to 90% of impact and are designed to bend without impeding movement.
Form fitted body and arms to provide maximum comfort with zero distractions.
KEY FEATURES
Anti-Bacterial
Enhanced with anti-bacterial treatment to reduce germs and odors
Impact Resistant
Armored with material that absorbs up to 90% of impact
Sweat-Wicking
Employs lightweight materials that wick moisture away from the body
