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 spike based on men's sizes. For women, order 1.5 sizes down (ex. For a women's 8.5, order a unisex 7.0).
Nike Zoom Rival
Track & Field Multi-Event Spikes
The Zoom Rival can endure those gritty, long practice sessions during the season and still help you flourish on meet day with its additional heel cushion and lightweight, durable upper. Still figuring out which events suit you best? These versatile spikes have you covered for sprints, hurdle events, jumps and pole vault. Lace up and dominate.
Comfort at the Heel
Added heel cushion provides comfort across short and middle distances, and hurdles and jumps. It gives cushion and durability for your footstrike and traction for post-race braking. Stay on Your Toes
An updated 3/4-length plate is lightweight, snappy and provides aggressive sturdiness to help keep you sprinting on your toes. Stick and Sprint
Six replaceable spikes offer optimal traction on all track surfaces. Lightweight ceramic aluminum material adds durability. Midfoot Containment
An arch band secures the midfoot for a dynamic lace-up fit and supportive containment needed in all events. No-sew overlays add support in the heel. Overlays on the toe tip offer durability in high-wear areas.
Padded collar provides comfort.
Forefoot mesh layered with reinforcement provides breathability and durability.
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