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
Designed to help you stay after even your most ambitious running goals, the Nike React Infinity Run Flyknit 3 offers a smooth and stable ride that's perfect for short and long routes. The breathable upper is made to feel contained, yet flexible. Added cushioning around the heel and ankle bring plush comfort, while earthy neutrals and playful summer-inspired details immerse you in nostalgic vacation vibes. Go ahead, take a break and get away for a run.
Breathable And Secure
Flyknit upper features specific zones of breathability. It's strong and durable, helping your foot feel secure and contained without being restrictive. Smooth And Steady Ride
Nike React technology delivers a smooth, responsive ride. Shaped like a rocker, the foam has been engineered to provide support for all 3 phases of a runner’s stride. It offers flexibility when your foot pushes off, has a smooth ride as your foot moves forward and cushioning for when your foot hits the ground. Cushioned Feel, Higher Stacks
Less material between the insole and midsole means you're closer to the foam. This helps create a more responsive experience, while a higher height of foam provides a softer feel.
Hybrid tongue combines a sock-like feel with the adjustability of traditional laces.
Cushioned collar provides soft comfort.
Rubber on the outsole helps deliver traction and durability.
A wide shape provides a more stable ride, helping release energy with every step.
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