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)
Go further than you thought possible with the women's GEL-CUMULUS® 21 performance road running shoe by ASICS. Designed to cushion and support your feet over long distances, this shoe boasts FLYTEFOAM® Propel technology for excellent bounce and energy. And now you can pick up this performance running shoe in a vibrant new design, created to inspire you to unleash your inner runner and let him shine. The combination of rear and forefoot GEL® technology means you benefit from a level of shock absorption not available in many other shoes, while GUIDANCE LINE™ technology enhances your gait efficiency and the internal heel counter holds your foot in position no matter how far you go. Further support comes from I.G.S® (Impact Guidance System) technology which enhances your natural gait as you move, and the EVA sockliner that molds to the shape of your feet for added comfort. The highly resistant AHAR® rubber compound reduces wear at key impact areas of the outsole, making this a performance running shoe that you can really count on as you look to reach new levels. Ventilation is provided by the engineered jacquard mesh upper, so you can rest assured that your feet will remain cool even when your run heats up. Reflective details on the outside of the shoe ensure you'll be noticed, even at lower light levels. With this exciting Shine design edition of the GEL-CUMULUS® 21 shoe in your training bag, you'll be able to take on those extra miles in comfort and style.
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