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)
The road from a high school track to an Olympic starting line is long and sometimes shadowy. Obstacles like chronic injuries, under-fueled nutrition, and coercive coaching can threaten to derail careers before they’ve even begun. Frustrated by seeing young talent burn out before reaching their potential, professional distance runner Molly Huddle and college coach Sara Slattery have teamed up with trailblazing running legends and sports medicine professionals to create an essential guide to reach your running potential.
This is How She Did It—an instructional and inspirational collection of stories and advice for female runners. The book begins with key information from the professionals who help make athletic excellence possible: trainers, physicians, nutritionists, and sports psychologists. Then, you’ll hear the first-person accounts of fifty women who’ve done it themselves. From the pioneers who fought tirelessly for women’s inclusion in the sport to the names splashed across headlines today, featured athletes include:
Joan Benoit Samuelson • Patti Catalano Dillon • Madeline Manning Mims • Paula Radcliffe • Deena Kastor • Brenda Martinez • Shalane Flanagan • Emma Coburn • Raevyn Rogers • Molly Seidel • and more
With Molly and Sara guiding the way, these athletes share their empowering stories, biggest regrets, funniest moments, and hard-won advice. Collectively, these voices are the embodiment of strength, meant to educate, inspire, and motivate you to see how far—and how fast—you can go.
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