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)
Nike Wildhorse 7
Women's Trail Running Shoes RUN WILD AND WITH PURPOSE.
Because in this sport, we all finish. The Nike Wildhorse 7 embraces the motto "Leave nobody behind," and it's inscribed on the tongue with a reflective print to shine through every run, night and day. It's durable, ventilated and supportive for every tough and rugged turn of the trail. Plus, a S-hook is connected to the laces so you can easily latch them to your bag and take them on the go.
Responsive Cushioning
Nike React foam offers a soft, smooth ride that adds a little spring to your step. Extra cushioning around the heel helps keep your foot secure. Breathable Durability
Mesh throughout the upper helps keep your foot ventilated and cool. Skins at the toe deliver durability for tough terrain. Multi-Surface Traction
Multidirectional traction lugs in the outsole are made from high-abrasion rubber. They help provide enhanced grip on descents and ascents. Keep Dirt Away
A gaiter collar around the ankle hugs your foot and helps keep dirt and debris out.
A Dynamic Fit System through the midfoot helps hug and support your foot as your run through rocky trails.
Segmented rock plate helps shield your foot on rough terrain.
Utility tab in the back for easy on and off.
More Details
Not intended for use as Personal Protective Equipment (PPE)
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