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)
GROUP BY b.attr1
ORDER BY max(b.attr1_order), max(b.attr1_entry_id)
For those who crave reliable comfort on any run, the Ride ISO 2 paves the way to smooth miles by delivering the best balance of cushioning and a highly-adaptable fit. The feel-good cushioning combo of PWRFOAM with an EVERUN topsole give this neutral running shoe just the right softness that's responsive enough to tackle high mileage.
Overview
Successor to the Ride ISO
EVERUNTM Topsole construction for enhanced energy return and continuous cushioning throughout the run
PWRFOAM midsole
Updated ISOFIT and all new FORMFIT technologies create a dynamic fit system by adapting to the shape and motion of the runner’s foot
Double jacquard mesh toebox provides structure or stretch where needed and enhances breathability
Improved heel grab and lockdown
Specs
Shoe Category: Neutral
Pronation: Neutral
Cushion: Moderate
Construction Type: Neutral
Surface: Road, Track
Arch: Normal (Mid)
Water Resistant: No
Waterproof: No
Offset: 8mm
Weight: 9.8 oz. | 278 g.
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