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 Trail 4
Women's Trail Running Shoes
It's time to get outside. Running is your daily ritual, taking you from road to trail as you seek out new routes and goals. With a supportive, springy feel, these trail runners can take you there and back again. Underfoot traction helps keep you going over rocky terrain while still providing a smooth ride for the road. Your trusted workhorse with wings is back and ready for an off-road adventure.
Light, Yet Tough
We used data from runners like you to create and place engineered mesh throughout the upper—in areas where it's needed most—for a lightweight and breathable feel. Plus, extra skins placed across the toes add durability. Supportive Steps
Flywire technology integrates with a midfoot band for total support that helps keep your feet in place. Energized Movement
Nike React technology is a lightweight, durable foam that delivers a smooth, responsive ride. Grip While You Rip
The generative traction pattern on the rubber outsole was created using data from runners like you. It provides grip in key areas to help you stay upright and stable when traveling over rocky trails and maintains a smooth ride on the road. Built to Resist Abrasion
Rubber from the outsole wraps up onto the forefoot to help resist abrasion and provide more durability.
Pull tab on heel
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