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 Rise 365
Men's Short-Sleeve Running Top LIGHT, SOFT AND VENTILATED.
A lightweight favorite returns with more breathability. The Nike Dri-FIT 365 Top is made with at least 75% recycled material and runner-informed data for cooling in areas where you need it. It has the same soft feel you've come to expect, with design details that nod to the iconic Nike chevron. This product is made with 100% recycled polyester fibers.
Lightweight and Soft
Knit fabric is brushed on both sides for a soft feel. The top's lightweight design drapes over the body, keeping you comfortable with every step. Optimal Breathability
Nike Breathe fabric moves sweat from your skin and features a highly breathable construction to help you stay dry and comfortable. Data-Enhanced Design
Open-hole knit fabric uses data from hundreds of runners. It's placed in high-heat zones at the front panel to help keep you cool on your run. Iconic Design
The top's knit structure forms the iconic Nike chevron at the front, nodding to the look of the Windrunner.
Dri-FIT technology helps you stay dry and comfortable.
More Details
Reflective elements
Not intended for use as Personal Protective Equipment (PPE)
100% polyester
Machine wash
Imported
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