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 (8742)
) 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 4880, 10

July 17, 2023

Kate McLaughlin and Ian Lopez de San Roman Win the Stages Cycling Tahoe Trail 100 MTB on Saturday at Northstar Resort

Leadville, Colo., (July 17, 2022)/ENDURANCE SPORTSWIRE/ – The Leadville Race Series Stages Cycling Tahoe Trail, owned and produced by Life Time (NYSE: LTH), took place this past Saturday at the world-class Northstar Resort. Straddling the borders of Nevada and California, the race brought more than 700 riders to the beautiful Sierra Nevada...

Cycling

Events

Press Releases

July 17, 2023

UltraSwim 33.3 x Precision Fuel & Hydration Partnership

/ENDURANCE SPORTSWIRE/ – We want every UltraSwim 33.3 participant to be a winner and that's why we've teamed up with Precision Fuel & Hydration to provide our participants with the education, tools and products to help them perform at their best. With their guided expertise, you'll be better prepared to nail...

Events

Press Releases

Sponsorship

July 17, 2023

Chargel Prepares to Fuel Up San Francisco Marathon Racers

IRVINE, Calif. (July 17, 2023)/ENDURANCE SPORTSWIRE/ –Chargel, the caffeine-free, pocket-sized and easy-to-consume athletic gel drink, will continue its California summer race sponsorship with its onsite attendance and product sampling at the 2023 San Francisco Marathon on July 21 – 23. The official gel sponsor of the San Francisco Marathon, Chargel will...

Events

Press Releases

Running

Sponsorship

Wire Syndication

July 17, 2023

De Rosa Bicycles announced as Official Bike Partner of RBC GranFondo Whistler 2023

[Vancouver, BC Canada]/ENDURANCE SPORTSWIRE/ - De Rosa Bicycles, one of the world’s most well-known and appreciated bike brands today announced a new partnership with RBC GranFondo Whistler, the first and largest Gran Fondo in North America, becoming the proud Official Bike Partner of the event. To celebrate, De Rosa will...

Business

Cycling

Events

Press Releases

Sponsorship

July 17, 2023

Lauren O’Brien introduced as the VIP and Volunteer Director for FRESHJUNKIE Racing

Baton Rouge, LA/ENDURANCE SPORTSWIRE/ – FRESHJUNKIE Racing (FJR), a leading sports event management company, is pleased to announce the appointment of Lauren O'Brien as the new VIP and Volunteer Director. Lauren brings with her a wealth of experience and a passion for community engagement, making her an invaluable addition to the...

Business

Press Releases

Running

July 16, 2023

McPherson, Kingsford win XTERRA Québec

/ENDURANCE SPORTSWIRE/ - Kieran McPherson (NZL) and Samantha Kingsford (NZL) won the 9th annual XTERRA Québec off-road triathlon elite races at Manoir du Lac Delage in the French-speaking region of eastern Canada on Sunday, July 16, 2023. It’s the sixth career XTERRA World Tour win for McPherson - his second...

Events

Press Releases

Triathlon

July 16, 2023

Vermette and Morrison Win 2023 Pro Enduro National Titles

RIDE ROCK CREEK, N.C. /ENDURANCE SPORTSWIRE/ - The 2023 USA Cycling Gravity Mountain Bike National Championships continued on Saturday in Zirconia, North Carolina. The national championship has attracted hundreds of top professional mountain bike racers from across the country. Stars-and-Stripes jerseys will be awarded in three disciplines, Downhill, Dual-Slalom, and...

Cycling

Events

Press Releases

July 16, 2023

Ropelato and Cushman Win 2023 Pro Dual Slalom National Titles

RIDE ROCK CREEK, N.C. /ENDURANCE SPORTSWIRE/ - The 2023 USA Cycling Gravity Mountain Bike National Championships have kicked off in Zirconia, North Carolina. The national championship has attracted hundreds of top professional mountain bike racers from across the country. A total of three events will determine the winners of the...

Cycling

Events

Press Releases

July 14, 2023

IRONMAN Announces Bike Course Changes for 2023 IRONMAN 70.3 Waco Triathlon

WACO, Texas (July 14, 2023)/ENDURANCE SPORTSWIRE/ – IRONMAN has announced that the IRONMAN® 70.3® Waco triathlon will return on Oct. 15, 2023 with an updated bike course. Still gently rolling through the beautiful countryside in the Heart of Texas, the new course looks to deliver smoother roads and substantially fewer turns...

Events

Press Releases

Triathlon

July 14, 2023

The RunnerBox and RiderBox Bring the Heat with their Newest Summer Edition

/ENDURANCE SPORTSWIRE/ – The RunnerBox and RiderBox announce the release of their newest subscription series, the Summer Edition. Shipping throughout June and July, the Summer Edition features thoughtfully curated gear and nutrition to help athletes make their summer training and racing as successful as possible. With items like protein to recover...

Cycling

Press Releases

Products

Running

Triathlon