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)
Nike Alphafly 2
Men's Road Racing Shoes
Once you take a few strides in the Nike Alphafly 2, you’ll never look at your favorite pair of old racing shoes the same. These rocket ships are made to help shave precious time off your personal records without surrendering the foundation you need to go the full distance. A thick, lightweight support system brings comfort and speed together so you can enjoy our greatest energy return yet while you chase your personal bests.
May the Miles Fly By
In anticipation of one of the biggest running races, we're celebrating the 20th anniversary of the Nike Mayfly, a popular ultra-lightweight racing shoe. Modernized graphics nod to the original Mayfly while bold race-day colors and Ekiden-inspired details celebrate the sport you love. Bounce to the Beat
Zoom Air units and full-length ZoomX foam bring you our highest energy return cushioning system yet, adding more bounce to every step. A thin rubber outsole enhances traction and allows for more ZoomX foam to be placed under the Zoom Air cushioning. The additional foam not only adds more bounce, but also helps improve transition from heel to forefoot. Stay Fresher, Longer
Full-length ZoomX foam offers an ultra-lightweight and responsive ride. It’s built for speed but also provides cushioning to help you stay fresh even in the last miles of a marathon. It offers comfort where you need it. Keep Rolling
Full-length carbon fiber plate delivers a sort of roll-forward feel that makes you want to take on the next step. It gives you a propulsive sensation and helps you smoothly transition through your stride. Both the forefoot and heel offer slightly wider bases for a stable platform, so you can tackle turns on the course with confidence.
Part of the Flyknit family—Atomknit material on the upper has a contoured fit w
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
