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 Shield
Men's Weatherized Road Running Shoes
Your workhorse with wings returns to help you push through the rain. A water-repellent finish helps keep you dry while a cozy fleece-like feel on the inside helps keep your feet warm for nasty-weather runs. Rugged traction and 2 Zoom Air units provide grip and soft cushioning, so you can power through the elements.
Warmth for Your Feet
Like a warm jacket for your feet, knit material in the upper helps keep your feet warm. Skins placed around the toes—in areas where water can seep in—help to keep you dry. Insulation in the back of the tongue helps your feet stay warm and comfortable. Dry Design
A water-repellent finish and gusseted tongue work together to help keep your feet dry. Heathered lining in the collar helps keep your ankle warm and dry. Rain-Ready Traction
The Storm-Tread outsole provides traction in wet weather. It has textures inspired by winter tires. Micro grooves grab the road, while multidirectional shapes help shed water for direct contact with the pavement. 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.
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