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)
Unisex road racing shoe based on men's sizing. For women, order 1.5 sizes down (ex. For a women's 8.5, order a unisex 7.0)
Nike Air Zoom Rival Fly 3
Road Racing Shoes A DURABLE DESIGN MADE FOR SPEED.
When you’re ready to ramp up the speed and go the distance, take off in a model that’s built for training and racing. Our latest version includes foam cushioning that’s softer than ever, and abrasion-resistant rubber for extra durability on rocky roads. With updates like these, you’ll be able to stay focused as you push towards the finish line.
Soft and Smooth
Updated foam provides softer cushioning than the previous version. It combines with a Zoom Air unit under the ball of your foot for a responsive, bouncy sensation when you push off. Ventilated Containment
Mesh feels light and breathable around your toes.
A traditional collar provides a comfortable fit for your heel.
High-abrasion rubber along the sole for durability.
An overlay that wraps around the toes makes it durable.
More Details
Center lacing
Not intended for use as Personal Protective Equipment (PPE)
Unisex road racing shoe based on men's sizing. For women, order 1.5 sizes down (ex. For a women's 8.5, order a unisex 7.0)
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