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 ZoomX Vaporfly Next% 2
Men's Road Racing Shoe THE ELITE RACING WORKHORSE.
Continue the next evolution of speed with a racing shoe made to help chase new goals and records. The Nike ZoomX Vaporfly Next% 2 builds on the model racers everywhere love. It helps improve comfort and breathability with a redesigned upper. From a 10K to a marathon, the 2 still has the responsive cushioning and secure support to push you towards your personal best.
This special edition colorway celebrates unity as athletes worldwide emerge from the year's past events to compete. It's a celebration of sport, humanity and our ability to push through the toughest challenges. Celebrate the Swoosh
The Swoosh design celebrates its 50th anniversary by intertwining the past and present. The original Swoosh logo is outlined over the current version, representing the path Nike has taken from yesterday to today. Best Energy Return Yet
Your foot sits on Nike ZoomX, our lightest and highest energy returning foam. Combined with a full-length carbon fiber plate, it feels smooth and responsive to keep you moving through your stride. Ultra-breathable and Soft
A redesigned upper uses mesh placed in areas where you need it. The result is a softer, more breathable shoe that conforms to your foot. Secure Containment
Reinforcement along the forefoot provides extra durability and containment.
A foam pod in the heel delivers comfortable cushioning while keeping it lightweight.
Light padding on the tongue helps reduce lace pressure.
The laces loop through lightweight side sashes that eliminate the need for an arch band. This helps reduce the shoe's weight.
A wider toe area gives a roomier fit.
Grooves on the sole give you flexibility and create tra
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