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)
The Endorphin Speed 2 is a natural winner, and now it's back and better than ever. Between its ultralight PWRRUN PB cushioning and responsive nylon plate, it's evident this shoe can do it all. From speed work to longer runs, from workouts to race day, it's more than ready to rock.
What’s new?
Snugger heel fit, more breathable mesh, soft suede detailing and anti-slip laces to lock it in.
Runners love this shoe while training for race days and shaving time off their miles – whether it’s a 5K, 10K, half or full marathon.
Pairs great with Endorphin Pro 2 for superior performance on race days // or the Endorphin Shift for max-cushioned everyday runs and recovery between speed days.
Features
SPEEDROLL Technology propels you forward effortlessly, so you can run faster, not harder
Full-length, responsive nylon plate gives you an edge for daily speed workouts and race day
Ultralight PWRRUN PB gives you incredible spring and energy return
FORMFIT hugs the foot in 3D comfort and delivers our most personalized fit yet
Engineered mono-mesh keeps the upper light and breathable
XT-900 outsole with reinforced high-abrasion zones provides optimal traction and durability
Shipping
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.
Returns
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:
Runners Plus
8970 Kingsridge Dr.
Dayton, OH 45458
