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 sizing. For women, order 1.5 sizes down (ex. For a women's 8.5, order a unisex 7.0)
Nike Zoom Rival
Track & Field Distance Spikes
With a lightweight, breathable upper and cushioned midsole, this adaptable spike dials you in for a wide range of middle- and long-distance races. It takes learnings from the game-changing Dragonfly spike to give you efficient energy return for the tough middle laps and top-end speed as you kick into the homestretch.
Cushion for the Push
Added cushioning at the midfoot and heel give you the comfort needed for longer distances and a smooth, propulsive transition for your footstrike. Lightweight Breathability
Single-layer mesh provides lightweight breathability in areas needed most without sacrificing proper containment. Spikes in Production
Four replaceable spikes offer optimal traction on all track surfaces. Lightweight ceramic aluminum material provides durability. Midfoot Containment
An arch band secures the midfoot for a dynamic lace-up fit and supportive containment needed in all events.
More Details
Ideal for events like 400m, 10,000m, hurdles, long jump, triple jump, pole vault and cross country.
Unisex spike 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
