Women's ASICS GEL-Cumulus 21

Style: 1012A468

Brand: asics

$120.00 $90.00

query

RESULTSET

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	NON_INVT	ORIGATTR1	QOH	SKU_ID	SORT_ORDER
1	BLACK/LASER_PINK	50501	[empty string]	[empty string]	N	BLACK/LASER_PINK	0	493602	[empty string]
2	BLACK/SUN_CORAL	50502	[empty string]	[empty string]	N	BLACK/SUN_CORAL	0	493618	[empty string]
3	PIEDMONT_GRAY/WHITE	50503	[empty string]	[empty string]	N	PIEDMONT_GRAY/WHITE	1	493634	[empty string]
4	VIOLET_BLUSH/DIVE_BLUE	50504	[empty string]	[empty string]	N	VTBDB	0	493650	[empty string]
5	Watershed Rose/Rose Gold	50505	[empty string]	[empty string]	N	WSRRG	0	493666	[empty string]
6	BLACK/WHITE	50506	[empty string]	[empty string]	N	BLACK/WHITE	0	493682	[empty string]

CACHED

false

EXECUTIONTIME

SQL

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,3) GROUP BY b.attr1 ORDER BY max(b.attr1_order), max(b.attr1_entry_id)

SQLPARAMETERS

array
1	36296

Colors:

Size: 5 5.5 6 6.5 7 7.5 8 8.5 9 9.5 10 10.5 11 11.5 12 13

Width REGULAR

description
shipping & returns

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 shipping is 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