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)
A sustainably crafted day-hiker designed for weekend adventures, the Anacapa Low GTX is a low-profile take on the Anacapa Mid. Engineered from lightweight leather certified by the Leather Working Group, the versatile silhouette employs recycled polyester in the collar, mesh and laces. Equipped with our Achilles-cradling pull tab and grounded in a 50% soy-based sockliner, this waterproof hiker is outfitted with GORE-TEX product technology with recycled textile designed to keep feet dry and comfortable in wet conditions. An innovative style that applies signature HOKA extended-heel geometry, the Anacapa Low GTX utilizes a Vibram® Megagrip outsole for superior traction in uneven terrain.
Protected with PFC-Free water repellency treatment
Leather Working Group Gold-rated waterproof nubuck leather
Gusseted tongue to mitigate trail debris
Recycled polyester content in collar, mesh and laces
GORE-TEX footwear fabric with recycled textile designed to keep feet dry and comfortable
Molded PU sockliner derived from 50% soybean oil
Compression molded EVA midsole for balanced, cushioned ride
Extended heel geometry for smoother heel-to-toe transitions
Grounded in a Vibram® MegaGrip rubber outsole
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