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)
Enjoy luxurious comfort and improved bounce with the women's GEL-KAYANO® 26 running shoe, featuring GEL® technology to the forefoot and rear for high-density shock absorption and a comfortable feel over long distances. Featuring a jacquard mesh upper and FLYTEFOAM® Propel technology for a lightweight quality that allows your feet to breathe, this ASICS running shoe is all about going the distance, providing exceptional support and comfort over long periods of time. The EVA sockliner offers excellent rebound and cushioning, while the Guidance TRUSSTIC SYSTEM® technology brings a new level of stability, working with the contoured midsole to help control torsion. Meanwhile, the SpEVA 45 lasting improves bounce-back characteristics to put a spring in your step (quite literally). If your feet tend to roll inwards as you run, fret not. The DUOMAX® midsole offers smooth overpronation control by combining two different density materials to reduce the risk of flat feet and bunions. Meanwhile, the AHAR® rubber sponge helps to reduce excessive wear for a longer lifespan. This edition of the GEL-KAYANO® 26 running shoe showcases a vibrant new design to inspire you to unleash your inner runner, on those days when you might need a little extra motivation, while added reflective details improve your visibility when you're out after-dark.
PRODUCT FEATURES: I.G.S® (IMPACT GUIDANCE SYSTEM) TECHNOLOGY: ASICS design philosophy that employs linked componentry to enhance the foot's natural gait from heel strike to toe-off.
REARFOOT AND FOREFOOT GEL® TECHNOLOGY CUSHIONING SYSTEM: Attenuates shock during impact and toe-off phases, and allows movement in multiple planes as the foot transitions through the gait cycle.
AHAR® OUTSOLE: Acronym for ASICS High Abrasion Rubber. Placed in critical areas of the outsole for exceptional durability.
TRUSSTIC SYSTEM® TECHNOLOGY: Reduces the weight of the sole unit while retaining the structural integrity of the
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