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
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)
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
HAVING sum(e.qoh+e.qc) > 0
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 $65+ 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. Damaged or defective items can also be returned for a full refund within 90 days. Please contact us with any inquiries.
Returns can be mailed to: Runners Plus
8970 Kingsridge Dr.
Dayton, OH 45458
