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. Men's sizing. For women, order 1.5 sizes down (ex. for a women's 8.5, order a unisex size 7.0)
Nike Air Zoom Maxfly
Racing Spikes RESPONSIVENESS WITH A SECURE FIT FOR ELITE SPEED.
The finish is only a quick sprint away. Let the lightweight feel of the Nike Air Zoom Maxfly take you there. Bounce at every step gives you the responsiveness to match your speed as you race to shatter personal goals. We added plenty of traction to give you extra grip for races from 100 to 400 meters with hurdles.
A Zoom Air unit at the forefoot gives you a light, responsive bounce when your foot connects to the track. 2 cushioned chambers within the air unit add even more stability and spring. It combines with a full-length carbon plate for a propulsive and stable feel as your foot takes off. The carbon is tuned in the midfoot and heel for a stiff feel where needed for better transition from heel to toe. Secure Steps, Light Touch
A woven and synthetic upper gives you secure, lightweight containment. Notched laces means less chance of them untying mid-run. Grip the Road
7 removable spikes at the forefoot help give you the traction needed to go your fastest. A shockwave pattern on the outsole, designed from athlete data, adds extra traction along the foot where you need it most.
Lightweight foam at the heel helps cushion your foot without adding weight.
Weight: 5.7oz (Men's size 8.5)
World Athletics approved
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.
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:
8970 Kingsridge Dr.
Dayton, OH 45458