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)
Give your feet a break even on the toughest days. The Glycerin 19 now features even more of our revolutionary DNA LOFT cushioning for the ultimate in softness. We even redesigned the interior for an even softer all-around feeling.
Our softest cushioning is called DNA LOFT. We designed it to feel super soft under your feet, yet remain durable and responsive. And did we mention that it’s lighter than ever?
Super soft, but never too squishy
Our cushioning technologies all start with DNA because they react to your unique stride.
A newly designed mesh upper stretches for a roomy-yet-secure fit and allows for more air flow. So there’s no need to choose between snug and breathable.
We’ve also updated the interior to be softer, so you’re surrounded by comfort.
We kept plenty of that super soft cushioning in the middle of the shoe, so going from heel to toe feels incredibly soft and smooth as you run.
No matter how your foot strikes the ground, smooth transitions ensure comfort.
If we got it right, you shouldn’t even notice transitions.
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
