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 React Infinity Run Flyknit 3
Men's Road Running Shoes
Engineered to help you pursue your running goals in comfort, the Nike React Infinity Run Flyknit 3 remains one of our most tested shoes. Its breathable upper helps your foot feel contained but flexible. Cushioning around the heel and ankle provide a supportive and comfortable sensation mile after mile. Plus, the unique rocker-shaped sole helps allow for a smooth and stable ride on both long and short routes. So keep running, we’ve got you.
Secure, Breathable Flex
We added Flyknit throughout the upper to create specific zones of breathability, flexibility and containment that helps your foot feel secure while still allowing it to move without restriction. Responsive Cushioning
Nike React technology is a lightweight, durable foam that delivers a smooth, responsive ride. Cushioned Feel, Higher Stacks
High-rise cushioning is placed directly under your feet so you're closer to the foam for a truly responsive experience. Smooth and Steady
Shaped like a rocker, the sole has been engineered to provide support during all 3 phases of a runner’s stride. It feels flexible when you push off, has a smooth ride as your foot moves forward and cushioning for when you hit the ground. Plus, a wider bottom allows for more stability on contact.
Hybrid tongue combines a sock-like feel with the adjustability of a traditional design.
Soft padding along the collar provides a cushioned touch point.
Additional rubber on the outsole provides traction and durability.
Not intended as Personal Protective Equipment (PPE)
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