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 (16)
) 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 1860, 10

August 22, 2023

U.S. Air Force Special Warfare to Partner With Spartan

BOSTON, MASS. (08/22/2023)/ENDURANCE SPORTSWIRE/ – Spartan, the world’s leading endurance sports and extreme wellness brand, announced that the U.S. Air Force Special Warfare will return as an Official Partner of select races in August 2023 to April 2024. “At Spartan, we pride ourselves on promoting the same traits military recruiters...

Events

Press Releases

Running

Sponsorship

August 21, 2023

Miami Nights Crowned Champions of the NCL Cup Series After Electrifying Weekend of Racing in Atlanta

ATLANTA /ENDURANCE SPORTSWIRE/ – The National Cycling League (NCL) wrapped up its thrilling three-part race series this weekend in Atlanta. On Saturday, Aug. 19, fans gathered at Bearings Bike Works for the Team Qualifier. The event was an embodiment of community spirit, where families came together to watch competitors push their...

Cycling

Events

Press Releases

August 21, 2023

XTERRA Costa Rica joins 2024 Americas Tour

/ENDURANCE SPORTSWIRE/ – XTERRA, the global leader in off-road triathlon, is pleased to announce the addition of XTERRA Costa Rica, presented by Coopenae, to the 2024 XTERRA Americas Tour. The three-day outdoor sports festival will be held August 23-25, 2024, at Las Catalinas, a beautiful car-free beach town in the...

Events

Press Releases

Triathlon

August 21, 2023

Rachel Zilinskas From the United States and Elliot-Olivier Pellerin from Canada Claim Victories At 2023 IRONMAN Mont-Tremblant Triathlon, Part of The Vinfast IRONMAN North America Series

MONT-TREMBLANT, QUEBEC, CANADA /ENDURANCE SPORTSWIRE/ - The picturesque international Resort of Tremblant and Quebec’s stunning Laurentian mountains provided a spectacular backdrop for the return of the IRONMAN® Mont-Tremblant triathlon, part of the VinFast IRONMAN North America Series as well as the IRONMAN 70.3® Mont-Tremblant triathlon which was originally due to take place...

Events

Press Releases

Triathlon

August 21, 2023

Athletes prepare to conquer world-famous Flüela Pass at Challenge Davos

/ENDURANCE SPORTSWIRE/ - With a double climb of the world-famous Flüela Pass featuring 1,770m of vertical, Challenge Davos on 26 August is one of the toughest and most iconic races on the Challenge Family calendar. After the 1.9km swim, athletes first climb the Flüela Pass from Davos: an ascent of...

Events

Press Releases

Triathlon

August 21, 2023

Rock ‘N’ Roll Running Series Continues Celebration of 25 Year Anniversary with Running Tour of Salt Lake City, Utah

SALT LAKE CITY, Utah /ENDURANCE SPORTSWIRE/ - The Rock ‘n’ Roll® Running Series is a best-in-class running series Bringing Fun to the Run® through music, entertainment, and community immersion all combining in Utah to provide an unforgettable running tour of Utah’s capital city. Rock ‘n’ Roll Salt Lake City presented...

Events

Press Releases

Running

August 20, 2023

Jacquie Mannhard and JP Giblin Win the 40th Annual Life Time Leadville Trail 100 Run presented by La Sportiva

Leadville, Colo., (Sunday, August 20, 2023) /ENDURANCE SPORTSWIRE/ - Celebrating its 40th year, the world-famous Leadville Trail 100 Run presented by La Sportiva race returned to Leadville this weekend, the pinnacle finale event of the 2023 Leadville Race Series. Event owner and producer, Life Time (NYSE: LTH) welcomed a field...

Cycling

Events

Press Releases

August 19, 2023

XTERRA Germany World Cup Weekend Wrap

/ENDURANCE SPORTSWIRE/ - Arthur Serrières (FRA) and Alizée Paties (FRA) made it a clean sweep by winning the XTERRA Germany full-distance off-road triathlon titles at Olbersdorfer See on Saturday, August 19, 2023, a day after capturing the XTERRA Short Track titles in Zittau. It’s the 24th career full-distance XTERRA World...

Events

Press Releases

Triathlon