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 Pegasus Turbo Next Nature
Men's Road Running Shoes
Although inspired by our past, this Nike Pegasus Turbo Next Nature is anything but old-fashioned. Thoughtfully made with at least 50% recycled content by weight, this esteemed stallion nods to the evolution of Nike Running with a design that pays tribute to Nike's early days as Blue Ribbon Sports. Stretchy high-strength fibers in the upper give you a just-right feel up top. Plus, lightweight and responsive ZoomX foam is designed to help you increase your Tempo without sacrificing comfort as you push toward your personal best. Your workhorse with wings is back. It's time to fly.
A More Responsive Ride
Nike ZoomX foam is responsive and lightweight, giving you bounce with every step. 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 and provides cushioning at ground contact. Lightweight and Supportive
Flyknit technology uses high-strength fibers to create a lightweight upper with targeted areas of support, stretch and breathability. It provides security and comfort. Traction for the Road
Waffle-inspired tread on the outsole provides durable traction.
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