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
Running is your daily ritual, and nothing stops you from striding closer to your personal goals. Let the Nike Air Zoom Pegasus 39 help you power toward that finish line with its comfortable, intuitive design. Underfoot cushioning and Zoom Air units in the heel and forefoot add a spring to your stride as you transition from heel to toe while a supportive sensation helps your foot feel contained. Your trusted workhorse with wings is back. Time to fly.
Total Comfort & Data-Backed Breathability
Extra padding at the tongue and collar helps your foot feel 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, breathable and durable. Supportive Steps
Flywire technology is integrated with a midfoot band for total support that helps keep your foot in place. Smooth Transition
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.
Rubber outsole provides traction while flex grooves throughout give you extra flexibility and a smooth feel on toe-off.
We designed the heel to help 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.
Not intended for use as Personal Protective Equipment (PPE)
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