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 Air Zoom Pegasus 39
Men's Road Running Shoes
Whether you prefer an extended route at sunrise or a quick jog at sunset, running is your daily ritual, and you need shoes just as dedicated. With its comfortable and intuitive design, the Nike Air Zoom Pegasus 39 offers a supportive sensation to help your foot feel contained. Underfoot cushioning and 2 Zoom Air units add a spring to your stride as you transition from heel to toe. Your trusted workhorse with wings is back. Time to fly.
Total Comfort & Data-Backed Breathability
Extra padding at the tongue and collar helps keep your foot feeling comfortable. Plus, we tested runners like you to find where cooling was needed most and placed engineered mesh—stronger and more flexible than regular mesh—throughout the upper using that data. The result is a shoe that's lightweight with breathable durability. Supportive Steps
Flywire technology is integrated with a midfoot band for total support that helps keep your foot in place. Snap, Run & Pop
Nike React technology is a lightweight, durable foam that delivers a smooth, responsive ride. We paired it with 2 Zoom Air units, at the forefoot and heel, for an energized feel at toe-off. The result is a smooth transition from heel to toe. Smooth Transitions, Durable Traction
Rubber outsole provides traction while flex grooves throughout give you extra flexibility and a smooth feel on toe-off. We designed the heel to optimize your landing, helping you easily transition from heel to toe.
Tongue is separated from the upper to give room for different foot shapes.
Reinforced toe tip adds durability.
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