SELECT SQL_CALC_FOUND_ROWS  wp_posts.*, IF(wppm.meta_value= 1, 'YES', NULL) as showcased
			 FROM wp_posts  LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_postmeta as wppm ON (wp_posts.ID = wppm.post_id AND wppm.meta_key = 'promoted')
			 WHERE 1=1  AND ( 
  wp_term_relationships.term_taxonomy_id IN (21084)
) AND wp_posts.post_type = 'post' AND ((wp_posts.post_status = 'publish')) AND wp_posts.ID NOT IN ( SELECT ID FROM wp_posts WHERE post_type IN ('post','page','attachment','job_listing','podcasts','industry-news','product','business-directory','testimonial') AND ID IN ( SELECT post_id FROM wp_postmeta pm WHERE pm.meta_key = 'groups-read' AND pm.meta_value NOT IN (0) AND pm.meta_value IN ( SELECT group_id FROM wp_groups_group ) AND post_id NOT IN ( SELECT post_id FROM wp_postmeta pm WHERE pm.meta_key = 'groups-read' AND pm.meta_value IN (0) ) ) )  AND wp_posts.ID IN  (    SELECT ID FROM wp_posts WHERE ID NOT IN ( SELECT post_id FROM wp_postmeta WHERE wp_postmeta.meta_key = 'groups-groups_read_post' )    UNION ALL    SELECT post_id AS ID FROM wp_postmeta WHERE wp_postmeta.meta_key = 'groups-groups_read_post' AND wp_postmeta.meta_value IN ('')  ) 
			 GROUP BY wp_posts.ID
			 ORDER BY wp_posts.menu_order,  wp_posts.menu_order, wp_posts.post_date DESC
			 LIMIT 430, 10

November 1, 2021

Showcased

St. Jude Heroes reach $100 million milestone for St. Jude Memphis Marathon Weekend

MEMPHIS, Tenn. (Nov. 1, 2021) / ENDURANCE SPORTSWIRE /– What does it take to keep St. Jude Children’s Research Hospital® running? If you’re a St. Jude Hero, that means running for a purpose for events like the St. Jude Memphis Marathon® Weekend presented by Juice Plus+®. For years, tens of...

Events

Giving

Press Releases

Running

October 27, 2021

Challenged Athletes Foundation Caps Off Raising Over $3.5m For Individuals with Physical Challenges at The CAF Community Weekend

SAN DIEGO, CA - October 27, 2021 /ENDURANCE SPORTSWIRE/ - Starting October, 15th and carrying through last weekend, The Challenged Athletes Foundation (CAF) finished a full line-up of fundraising events including the Million Dollar Challenge seven-day California coastal ride raising over $2.2M, the Community Challenge powered by Strava -featuring the Aspen...

Giving

Press Releases

Triathlon

October 25, 2021

Team Evergreen Donates $500,000 in 2021

EVERGREEN, CO /ENDURANCE SPORTSWIRE/ - Team Evergreen Cycling, Colorado’s largest cycling club, is thrilled to announce a $500,000 donation for 2021 through the proceeds of the Triple Bypass, Mt. Evans Hill Climb, Co2uT, Session Series, the Hundo, and Beti Bike Bash. This record-breaking Team Evergreen donation will be divided into...

Cycling

Giving

Press Releases

October 21, 2021

New Program Aims to Improve Diversity in Endurance Coaching

Lehi, UT: /ENDURANCE SPORTSWIRE/ - The 80/20 Endurance Foundation today announced the launch of the Coaches of Color Initiative, an innovative program that aims to enhance diversity in endurance sports by awarding apprenticeship grants to persons of color who aspire to successful careers as endurance coaches. The first grant will...

Business

Giving

Press Releases

October 19, 2021

“Show Your St. Jude Spirit” campaign to rally global community for 20th annual St. Jude Memphis Marathon Weekend

MEMPHIS, Tenn. (October 19, 2021) /ENDURANCE SPORTSWIRE/ - St. Jude Memphis Marathon® Weekend presented by Juice Plus+® today announced a new Show Your St. Jude Spirit campaign to celebrate 20 years running and unite St. Jude supporters in Memphis and beyond to generate funds for the lifesaving mission of St....

Giving

Press Releases

Running

October 18, 2021

Ride Santa Barbara 100 Celebrates 10th Anniversary This Weekend

SANTA BARBARA, Calif. – Oct. 18, 2021 /ENDURANCE SPORTSWIRE/ - After a pandemic-forced hiatus in 2020, Ride Santa Barbara 100 (RideSB100), the premier cycling event set on California’s Central Coast, returns to Leadbetter Beach this Saturday October 23, 2021, with its largest event in 10 years. Registration is sold out...

Cycling

Events

Giving

Press Releases

October 18, 2021

IRONMAN Foundation to Provide $35,000 in Charitable Giveback to Northern California Community in Conjunction with IRONMAN California

SACRAMENTO, Calif./TAMPA, Fla. (October 18, 2021) – In conjunction with the IRONMAN® California triathlon, the IRONMAN Foundation® will continue its mission of creating tangible impact in IRONMAN race communities throughout Northern California next week, by distributing over $35,000 in grants to nonprofit initiatives within the region. In addition, the IRONMAN Foundation...

Events

Giving

Press Releases

Triathlon

October 15, 2021

Diamondback’s Eat My Dust Gravel Scholarship Returns for its Second Year

KENT, Wash., (October, 15, 2021) — Diamondback, a leader in the gravel cycling space, and professional triathlete and gravel racer Rach McBride have teamed up for the second annual Gravel Scholarship. This year with a new name, the Eat My Dust Gravel Scholarship, which will aim to encourage more female,...

Cycling

Giving

Press Releases

Triathlon