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 3170, 10

May 29, 2023

Registration Prices Increasing Soon for The Pikes Peak APEX

/ENDURANCE SPORTSWIRE/ – Registration Prices Increasing Soon for The Pikes Peak APEX: Secure Your Spot Now and Save! NEW WEBSITE We've recently launched a new website for the Pikes Peak APEX presented by RockShox and have receive feedback that some users are experiencing issues loading the site. To resolve this, we...

Cycling

Events

Press Releases

Running

May 28, 2023

Serrières, Karásková win XTERRA Lake Garda

/ENDURANCE SPORTSWIRE/ - Arthur Serrières (FRA) and Helena Karásková (CZE) were crowned King and Queen as winners of the XTERRA Lake Garda off-road triathlons with winning times of 2:46:34 and 3:25:09, respectively, on a perfect day in Toscolano Maderno located on the shore of the largest lake in Italy, on...

Events

Press Releases

Triathlon

May 28, 2023

Ryan Sandes (RSA) and Sylvie Scherzinger (RSA) claim victories at the first ever UTMB® World Series event in Africa, winning the men’s and women’s 100-Miler distance category

(GEORGE, South Africa) 28 May 2023 /ENDURANCE SPORTSWIRE/ - An action-packed weekend in George, South Africa saw Ryan Sandes (RSA) and Sylvie Scherzinger (RSA) claim victories at the first ever UTMB® World Series event in Africa, winning the men’s and women’s 100-Miler distance category at the inaugural Mountain Ultra Trail...

Events

Press Releases

Running

May 26, 2023

IRONMAN Announces Phu Quoc in Vietnam as New Host of IRONMAN 70.3 Triathlon

HO CHI MINH CITY, VIETNAM / TAMPA, Fla. (May 26, 2023)/ENDURANCE SPORTSWIRE/ – IRONMAN announced today that Phu Quoc, Vietnam will play host to the newest IRONMAN® 70.3® triathlon in Asia. The inaugural IRONMAN 70.3 Phu Quoc triathlon is scheduled to make its debut on Sunday, November 19, 2023, taking athletes on...

Events

Press Releases

Triathlon

May 26, 2023

17th Denver Colfax Marathon Welcomes Record Number of Runners to the Mile High City

Denver /ENDURANCE SPORTSWIRE/ - The Denver Colfax Marathon, presented by Cigna, welcomed a record 21,000 runners to its annual spring marathon weekend this year. Denver’s largest running event and only marathon weekend took place May 19-21, 2023. “There was an undeniable energy surrounding each race this year,” said Andrea Dowdy,...

Events

Giving

Press Releases

Running

Sponsorship

May 26, 2023

Ascension Seton CapTex Tri Returns for Memorial Day 2023

AUSTIN,Texas, May, 2023/ENDURANCE SPORTSWIRE/ – The annual Ascension Seton CapTex Tri returns this year, where over 2300 triathletes from across 26 states and 4 countries will converge on Memorial Day weekend in the capital city. CapTex Tri features a swim course in Lady Bird Lake, a bike ride through downtown Austin,...

Events

Press Releases

Triathlon

May 25, 2023

Volvo Becomes Title Sponsor of the Santa Monica Classic

LOS ANGELES, CA (May 25, 2023) /ENDURANCE SPORTSWIRE/ - The McCourt Foundation (TMF) today announces that Volvo Car USA has expanded its on-going sponsorship of TMF events by becoming the Title Sponsor of the 2023 Volvo Santa Monica Classic presented by ASICS in September. Through its title sponsorship of the...

Events

Press Releases

Running

Sponsorship

May 25, 2023

Extreme Athlete Jonas Deichmann Crosses the USA. Unsupported. TWICE.

ENDURANCE SPORTSWIRE/ - Adventurer and multiple world record holder Jonas Deichmann has a new project – cycling from New York to Los Angeles and running back. German adventurer Jonas Deichmann will start his next adventure at the end of June from New York City as he sets off in late...

Cycling

Giving

Press Releases

Running

May 25, 2023

Star U.S. Elite Triathletes to Race At World Triathlon Championship Series Cagliari

COLORADO SPRINGS, Colo./ENDURANCE SPORTSWIRE/ – U.S. elite triathletes including No. 2 world ranked Taylor Spivey (Redondo Beach, Calif.) and Olympic medalists Katie Zaferes (Cary, N.C.) and Gwen Jorgensen (Boulder, Colo.) will compete this Saturday, May 27, in Cagliari, Italy, at the 2023 World Triathlon Championship Series Cagliari. Cagliari will see 10 U.S. elite triathletes compete at the third...

Events

Press Releases

Triathlon

May 25, 2023

XTERRA Italy – Lake Garda pits Serrières vs. Kulhavý

/ENDURANCE SPORTSWIRE/ – The sixth stop on the 2023 XTERRA EMEA Tour takes participants to the town of Toscolano-Maderno on the western shores of Lake Garda in Italy this Saturday, May 27, for one of the toughest off-road triathlon challenges on the global circuit. "You cannot start this race hoping...

Events

Press Releases

Triathlon