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)
U.S. Soccer 2020 Stadium Away (4-Star)
Women's Jersey YOUR TEAM. YOUR COLORS.
Rep your team in the U.S. Soccer Stadium Away (4-Star) Jersey. Highly breathable fabric helps keep sweat off your skin, so you stay cool and comfortable on the field or in the stands. Bringing streetwear and fashion culture to the pitch, the camouflage pattern is inspired by the global influence the U.S. has on sport.
Nike Breathe fabric features highly breathable construction to help you stay cool. Nike Dri-FIT technology moves sweat from your skin to help you stay dry and comfortable. Elite Inspiration
Authentic design gives you the same look worn by your favorite players on the field. The Nike Futura logo is featured for the first time on a U.S. soccer jersey.