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,4)
GROUP BY b.attr1
ORDER BY max(b.attr1_order), max(b.attr1_entry_id)
The GEL-DS TRAINER™ 26 running shoe is the recommended choice for runners covering shorter distances who want to go fast. The shoe helps you achieve those running goals with an improved upper fit that moves seamlessly with the runner's natural motion. Updated with a soft and flexible knit upper, this application helps the shoe move more naturally with the runner's foot.
Accented with a series of reflective details, this design element is practical for runners who are training in low-light conditions. Added support stems from the updated sockliner, which naturally contours to the foot's shape while improving comfort. Following a more sustainable design approach, this shoe also uses fewer resources to color the sockliner.
Functional for overpronators, the shoe's DUOMAX® technology on the midsole's medial side helps reduce the foot's pronounced inward roll and improves support. GEL® technology cushioning improves shock absorption, while the FLYTEFOAM® midsole material provides a soft and supportive feel from footstrike to toe-off. The PROPULSION TRUSSTIC™ technology in the outsole mirrors the foot's ligaments, creating a powerful lever to propel your stride. Formulating a smoother transition throughout your stride, this shoe is also complemented with an AHARPLUS™ heel plug to improve durability and expand its lifespan.
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