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 One Luxe
Women's Standard Fit Long-Sleeve Top ELEVATED COMFORT FOR ANY WORKOUT.
The Nike Dri-FIT One Luxe Top is designed for all the ways you work out—from yoga to HIIT to long runs. As part of the Nike Luxe line, this top defines luxury with buttery-soft and smooth fabric that breathes to keep you dry and cool. It's made with at least 75% recycled polyester fibers.
Luxe Is More
Part of the Nike Luxe line, this top takes comfort to the next level with buttery-soft fabric that feels incredible. It gets even better with a reflective Swoosh logo on the chest. Sweat It Out
The breathable design with Nike Dri-FIT technology moves sweat away from your body for quicker evaporation, helping you stay dry and cool. Move in Comfort
Soft, smooth fabric curves down at the back hem for a little more coverage. Small side slits create extra give while you move.
Not too tight or too loose, the design highlights your natural shape without feeling restrictive.
"Just Do It." print at the interior hem delivers an inspirational message—just for you.
Standard fit for a relaxed, easy feel
Not intended for use as Personal Protective Equipment (PPE)
83% polyester/10% spandex/7% lyocell
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