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)
GROUP BY b.attr1
ORDER BY max(b.attr1_order), max(b.attr1_entry_id)
Nike ZoomX Invincible Run Flyknit 2
Men's Road Running Shoes
Avoiding injury is crucial no matter if you’re tackling a 20-miler in the middle of marathon prep or stockpiling tempo runs together. Specifically designed to offset the attrition of your toughest trainings, these shoes boast a stack of mattress-like cushioning to help you stay on your feet mile after mile. Earthy neutrals and playful summer-inspired details add a nostalgic vacation feel, while an unbelievable sense of springy propulsion provides responsive comfort that lets you focus on your run—not the potential repercussions.
More Bounce with Every Ounce
Nike ZoomX foam is responsive and lightweight, giving you bounce with every step. Shaped like a rocker, the foam provides support for the 3 phases of a runner's stride. It offers flexibility when your foot rises off the ground, a smooth ride when your foot is moving forward and cushioning at ground contact. Secure, Cushioned, Comfortable
Our Flyknit upper helps keep your feeling comfortable and stable as you pound the pavement. Seamless engineering at the tongue creates cushy padding and an adjustable fit while the soft vamp offers your foot a secure and supportive feeling. A beveled heel clip adds cushioning and containment. Higher, Softer, Wider
Higher foam heights provide an even softer feel. A wide, exaggerated shape at the forefoot offers a more stable ride. Created with Data
We used runner-informed data to create a Waffle outsole with traction where you need it most. That data also helped guide the design and look of the shoe's sidewalls.
More Details
Reflective elements
Not intended for use as Personal Protective Equipment (PPE)
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
