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 Invincible 3
Women's Road Running Shoes
With maximum cushioning to support every mile, the Invincible 3 gives you our highest level of comfort underfoot to help you stay on your feet today, tomorrow and beyond. Designed to help keep you on the run, it’s super supportive and bouncy, so that you can propel down your preferred path and come back for your next run feeling ready and reinvigorated.
Support: High
The more supportive the shoe, the more stability it can give to your natural stride. A combination of tuned support and intentionally placed cushioning helps you feel secure with every step. The Invincible 3 has high support technology, with cushion and stability intentionally placed and shaped to protect your foot from the effects of pronation. Cushioning: Super High
The more cushioning that you have underfoot, the softer and more comfortable your running experience can be. Cushioning helps soften impact as your feet hit the ground. With Nike ZoomX cushioning shaped like a rocker and higher foam heights, this shoe gives you ultimate cushioning at ground contact and an even softer underfoot feel. Responsiveness: Super High
The more responsive the shoe, the more energy return you can get back with each step. Whether you want to run a little bit faster or with a little less effort, responsive shoes help give you slightly more spring in your step to get more out of your run. Nike ZoomX foam is ultra responsive and lightweight, giving you bounce and a snappy response with every step. Fit: Secure, Breathable, Comfortable
An evolved Flyknit upper places zones of breathability where your foot heats up most. It's strong and durable, helping keep your foot secure with every mile. What's New About the Invincible 3?
We made the heel clip smaller than our previous iteration an
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