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)
Smoother and softer, your updated Men's Brooks Ghost 14 running shoes are back even better. The cushy feel has made this a runner favorite for years, and now you get 100% DNA LOFT cushioning through the midsole to take smoothness even further. Transitions from landing to toe-off flow easier with the segmented crash pad working in tandem with the cushier midsole. Your Ghost 14 even adjusts more comfortably to your foot thanks to the 3D Fit Print balancing the perfect amount of stretch and structure.
Running Shoe Support: Neutral runners with medium to high arches that don't need extra support will love the soft, smooth feel of the Brooks Ghost 14.
Cushion Level: Mid-Level Cushion feels springy and lands soft on both long and short runs.
Midsole Drop: Your men's Brooks Ghost 14 has a heel to toe drop of 12 mm.
Shoe Weight: 9.9 ounces
Perfect For: Runners who like to hit the streets or paved paths for their daily runs and training.
Breathable Support: New 3D Fit Print upper with breathable, engineered mesh offers just-right support while maximizing airflow.
Softer Landings: Segmented crash pads and a new softer midsole ensure every landing is soft and smooth.
Irritation-Free: A plush comfortable collar reduces chafing while keeping the fit soft and secure.
Stretchy Structure: Give your feet a bit of flexible guidance with a 3D Print Fit Saddle and Heel Overlay.
Durable Construction: Grip and go with a blown rubber forefoot and HPR heel rubber that's tough and long-lasting.
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