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
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)
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)
GROUP BY b.attr1
HAVING sum(e.qoh+e.qc) > 0
ORDER BY max(b.attr1_order), max(b.attr1_entry_id)
Nike Zoom Pegasus 35 Turbo
Men's Running Shoe
TRAINING, TURBO CHARGED.
Elite Nike runners in Kenya tested and provided feedback for the Nike Zoom Pegasus 35 Turbo Men's Running Shoe. Bringing record-breaking innovation to your daily training, Nike ZoomX foam delivers revolutionary responsiveness while the feather light upper looks as fast as it feels.
Nike ZoomX foam delivers Nike Running's greatest energy return yet.
Incredibly lightweight for optimal speed.
Translucent upper looks and feels fast.
Heel collar has been engineered to taper away from the foot for comfort around the Achilles tendon.
Flywire cables integrate with the laces to wrap the midfoot and arch for a secure, dynamic fit.
ZoomX foam sits directly under your foot for heightened responsiveness.
Exaggerated dropped Swoosh extends onto the midsole. This is consistent across all Nike ZoomX foam Running shoes.
Weight: 8.5oz/242g (men's size 10) Last: MR-10 Offset: 10mm (12 mm forefoot, 22 mm heel) Athlete: Eliud Kipchoge