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)
Feel the confidence to push your run further with the re-engineered ASICS® GEL-NIMBUS 21 men's running shoe, designed to offer ultimate comfort and a perfect fit. These luxurious sports shoes for men feature an innovative midsole set-up that incorporates FLYTEFOAM® Propel technology to give you maximum bounce on the forefoot and to help move you forward.
Perfect for long distance runs, these ASICS® men’s running shoes bring comfort wherever you’re training. A new engineered mesh offers you more breathability and support, and a spacious toe-box and GEL® cushioning on the forefoot give your feet more space to move. There’s also an external clutch counter to provide your heel with the ultimate support, an Ortholite collar sponge that provides effective moisture management, and a molded EVA sockliner that helps keep your feet comfortable and dry as you tear up the terrain.
With the ASICS® GEL-NIMBUS 21, you’ll feel the energy for an endless run. The addition of SPeVA® 45 lasting foam doesn’t just absorb shock – it also increases durability and rebound. An all-new lateral full contact outsole gives you a smoother, more stable ride from heel strike to toe off.
Comfortable, clever and stylish, the ASICS® GEL-NIMBUS 21 running shoes are the ideal choice for anyone looking for the ultimate way to go further.
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
