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)
Nike Dri-FIT ADV Team USA AeroSwift
Men's 1/2-Length Racing Tights STRETCHY, RACE-READY SUPPORT. FOR THE USA.
The Nike Dri-FIT ADV Team USA AeroSwift Tights are all about the speed you need to get across the finish line. Made with advanced technology, they're light and mobile, helping you push for your personal best. They celebrates Team USA as they live their dream on the world stage.
Celebrate the hard work and perseverance of those giving it all in competition. These track and field kits were designed for Team USA with the latest innovations to help push athletes to the next level. Find Your Fast
The AeroSwift Collection is Nike’s pinnacle racing gear. It's made for speed using the latest innovation, delivering optimal performance and distraction-free coverage. Streamlined designs are lightweight and sleek, helping you move freely as you focus on the finish line. Streamlined Speed
Nike Dri-FIT ADV technology combines moisture-wicking fabric with advanced engineering and features to help you stay dry and comfortable. It pairs with a lightweight, breathable fabric for a supportive and smooth feel.
Tight fit for a body-hugging feel
We offer free standard shipping on all orders $50+ and a flat rate on all orders under that amount. Expedited shippingis available in checkout for a shipping premium.
Any unworn product can be returned for a full refund within 90 days. We do not offer free return shipping except in cases of defective items. These can be returned for a full refund within 90 days at no expense to you. Please contact us with any inquiries.
Returns can be mailed to:
8970 Kingsridge Dr.
Dayton, OH 45458