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)
Women's SAUCONY® TRIUMPH 19 : Lose track of the miles with your updated Women's Saucony Triumph 19 running shoes. With a plush and responsive bed of PWRRUN+ foam, even your longest runs feel luxuriously cushioned. Enjoy the light-as-air feel thanks to the new mono-mesh upper and articulated eyerow providing a sleek, sock-like fit adapting to your foot. The plushness continues in your Triumph 19 with soft suede on the tongue and sides so you look forward to your long run all week.
Running Shoe Support: Built for neutral runners who don't need a lot of extra support the Saucony Triumph 19 is a perfect choice for medium to high arches.
Cushion Level: Max Cushion maximizes that plush feel, so every step feels soft and smooth no matter how far you're running.
Perfect For: Perfect for long distance running, workouts and daily training on paved trails and roads.
Midsole Drop: Your women's Saucony Triumph 19 has a heel to toe drop of 8 mm
Shoe Weight: 9.1 ounces
Ultra Breathable: A new engineered monomesh upper offers lightweight support while maximizing airflow.
Custom Comfort: Soft suede tongue and side detailing and an articulated eye row adds comfort while maintaining a unique look and style.
25% Lighter: Run fast with a durable PWRRUN+ midsole cushion that feels ultra-flexible while keeping the overall feel lightweight.
Sustainably Made: Recycled materials make the Triumph 19 an eco-friendly choice for runners focused on reducing their carbon footprint.
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