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 3
Women's Road Running Shoes
Stay on your feet with soft and supportive cushioning, built to help keep you on the run. A wider forefoot and higher foam stacks help shield you from recurring attrition, giving you the peace of mind to pound the pavement every day. The springy responsiveness will surprise you too, adding an element of pure speed to 1 of our most tested shoes to help you go longer, faster and farther than ever.
We updated the Swoosh design and added a couple of extra shielding skins to drive the new color block, so that you can stay upright in style. Smooth Ride
Nike React technology is a lightweight, durable foam that delivers a smooth, responsive ride. 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. Adjusted Tongue
Fully adjustable Flyknit tongue can be pulled out for a style perspective or toggled and tailored to different types of runs. It works with Flywire to create that just-right sensation of comfort and security. Non-knit collar is made of supersoft foam that complements the Flyknit. Breathable at All Times
An advanced Flyknit upper provides breathability where you need it most. It's strong and durable, helping to keep your foot secure with every mile. Flywire technology offers extra support and stability through the midfoot.
Increased rubber at the outsole helps deliver traction and durability.
Cushioned collar provides soft comfort.
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