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)
Protect areas of skin prone to chafing and blisters with the world's best all-natural, anti-chafe salve. Coconut oil and cocoa butter create a slick, lasting barrier on the surface of your skin to prevent rubbing and irritation. Beeswax makes the slick barrier effective and long-lasting as it holds the oil and butter in place to keep your skin moisturized and chafe-free. That's why the happiest squirrels butter their nuts!
Know This This product includes only natural ingredients. Product hardens in colder temperatures. The stick is the best application method in cold weather. Oil separation and irregular finish is natural.
Directions for Use To prevent chafing and blisters, apply before activity directly to any skin prone to chafing or blisters, including underarms, thighs, crotch, nipples and feet, or under your bra or pack straps. Re-apply as needed.
Benefits
Superior anti-chafe, anti-blister properties
Weather resistant & long lasting
No synthetic ingredients
Easy-to-apply stick
Effective on eczema and other skin irritations
Also works extremely well to restore dry or cracked hands, feet and face
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
