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)
It started with a dream: to have that simple, easy, sandal that was designed specifically for the relaxed side of the sport life. More than a year in the making, we're thrilled to introduce the world to our first footwear style. Like everything we make, we looked at the problem from all angles and came up with a list of wishes: a massaging footbed for tired feet, a heel strap for when we had to pick up and run, a no-slip tread for staying on our feet, and a material, 100% soft-foam EVA, that's comfortable in all the elements. Just add five fun colors and we're able to say that the goal of combining function and fashion is more than a dream. The Sport Sandal fit is relaxed, with space for gentle movement and easy on/off. Wear testers report it fits true to size. If you are between sizes, we recommend going with the smaller size.
- 100% EVA Soft Cushion Foam
- Massaging dots footbed
- Arch support and heel strap
- Ridged bottom for no-slip traction
- Multi-function use, including water shoe
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