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 FlyEase
Women's Easy On/Off Road Running Shoes ENERGIZED FOR MILES.
Running is your daily ritual, with every step taking you closer to your personal goal. Let the Nike Air Zoom Pegasus FlyEase help you ascend to new heights with its comfortable, intuitive design. A supportive sensation helps keep your foot contained, while underfoot Air adds a pop to your step as you transition from heel to toe. Nike FlyEase technology acts as a strap, helping secure the fit. Your trusted workhorse with wings is back. Time to fly.
Strap In and Go
A FlyEase strap over the upper lets you easily slip in and out of the shoe. Use the strap to help secure the fit. Total Comfort
We tested runners like you to find where your foot needed cooling the most. Using that data, we placed engineered mesh—stronger and more flexible than regular mesh—throughout the upper for lightweight and breathable durability. Extra padding at the tongue and collar helps keep your foot feeling comfortable. Supportive Steps
Flywire technology is integrated with a midfoot band for total support that helps keep your foot in place. Snap, Run and Pop
Nike React technology is a lightweight, durable foam that delivers a smooth, responsive ride. We paired it with a Zoom Air unit at the forefoot and heel for an energized feel at toe-off. The result is a smooth transition from heel to toe. Smooth, Durable Transitions
A rubber outsole with a Waffle-inspired pattern provides traction. 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.
We tuned the shoe for your foot, giving you
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