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)
Nike Rise 365
Men's Running Top LIGHTWEIGHT VERSATILITY WITH EVERY MILE.
The Nike Rise 365 Top delivers versatile performance for everyday running. Designed for lightweight mobility, the top features soft fabric with increased ventilation where you need it most. This product is made with 100% sustainable materials, using a blend of recycled polyester and organic cotton fabrics. The blend is at least 10% recycled fabric or at least 10% organic cotton fabric.
Feels Soft and Lightweight
The lightweight knit fabric feels soft to the touch and helps you move freely. Breathable Where You Need It
Mesh fabric at the back and underarms provides breathability. It's placed in high-heat areas for maximum ventilation. Longer In the Back
Elongated back hem extends your coverage. All in the Details
A Swoosh design and other reflective elements are placed throughout the body.
Dri-FIT technology helps you stay dry and comfortable.
More Details
Standard fit for a relaxed, easy feel
Rolled shoulder seams
Extended coverage at the back
Elastic neckband
Internal neck tape with "Nike Running" graphic
91% recycled polyester/9% cotton
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