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 Saucony Omni 20 for women are running shoes for overpronating runners. Like many other updated Saucony models, the ISOFIT upper found in the previous version of the Omni has been replaced with the new FORMFIT upper. What hasn't changed is the level of comfortable support which has come to define the Omni model. So, the Omni 20 offers the familiar level of support, but now also ensures a much smoother transition.
The PWRRUN midsole provides the perfect balance between cushioning and responsiveness. Thanks to this comfortable cushioning and excellent energy return you'll be able to go on for longer. The Omni 20 is made for overpronators. Thanks to the reinforcement on the medial side of the shoes, they know to provide the right amount of support. Instead of a hard correction in the upper, the Omni 20 guides you smoothly through the heel-to-toe transition. This makes the shoes very comfortable and also reduces the weight of the shoes.
The Omni 20 also features the Speedroll technology in the forefoot which helps ensure a smooth heel-to-toe transition. Thanks to the innovative technologies used in these shoes, the Omni 20 a lot of comfortable miles to come.
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