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 Epic Luxe
Women's Running Crop Tights EPIC RUNS ON REPEAT.
The Nike Epic Luxe Tights deliver the soft, sleek and breathable comfort you love. Nike's highest-quality fabrics—a feature of our Luxe tights and leggings—combine with a lightweight, compressive feel. They use a mid-rise waistband for an ultra-flattering fit. Multiple easy-access pockets carry a key or card along for the journey.
Luxe is More
Luxe tights feature Nike’s highest-quality fabrics and features. They use a premium fit and feel, with a soft touch for all levels of running. The tights are supportive in all the right ways, keeping you focused on the road ahead. Supportive, Breathable Comfort
Nike Power fabric provides a range of stretch and support to help you power through whatever your run demands. Perforations at the back calf let cool air in and heat out. Flattering and Functional
A seam added to the back yoke elevates the design, and the gusset's shape has been updated for comfort. Multiple Pockets
Drop-in pockets give you easy access to essentials. A zippered pocket at the back can hold a phone, while a drop-in pocket at the front left hip stashes keys or cards.
More Details
Tight fit for a body-hugging feel
Mid-calf length
Raw-cut hem
Reflective details
Adjustable drawcord
75-78% polyester/22-25% spandex
Material percentages may vary depending on color. Check label for actual content.
Machine wash
Imported
Not intended for use as Personal Protective Equipment
Shipping
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.
Returns
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:
Runners Plus
8970 Kingsridge Dr.
Dayton, OH 45458