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

October 17, 2023

XTERRA Australia 2024: Dynamic Races Await in Dunsborough

DUNSBOROUGH, Western Australia /ENDURANCE SPORTSWIRE/ – The picturesque coastal town of Dunsborough is once again set to host XTERRA Australia in 2024. This event has rapidly gained a reputation as one of the premier off-road triathlons on the global circuit. Scheduled for April 20-21, it promises to be a blend of...

Events

Press Releases

Running

Triathlon

October 17, 2023

The 2023 IMT Des Moines Marathon Shatters Registration Targets For All Events

Des Moines, IA /ENDURANCE SPORTSWIRE/ – The 2023 IMT Des Moines Marathon race weekend smashed expectations for race organizers and participants of the IMT Des Moines Marathon & Half Marathon, the Bankers Trust Marathon Relay, the Principal 5K Road Race, and the MercyOne Children’s Hospital Kids Run. Held on Sunday, October...

Events

Press Releases

Running

October 17, 2023

Key West Half Marathon & Runfest Reveals Shirts and Medals for 2024 Race

KEY WEST, Fla. /ENDURANCE SPORTSWIRE/ – The Key West Half Marathon & Runfest, rated a top 10 half marathon by USA Today, is back on Jan. 14, 2024. The event has unveiled new race day shirts that feature artwork by local artist Taylor Hale. Participants will also receive a newly designed...

Events

Press Releases

Running

October 16, 2023

Over 1,300 Registered Runners Took on Kodiak Ultra Marathons by UTMB Over Three Days

BIG BEAR LAKE, Calif. /ENDURANCE SPORTSWIRE/ - The 2023 UTMB® World Series continued with the 2023 Kodiak Ultra Marathons by UTMB® on Oct. 13 - 15. The 10th anniversary of the race featured over 1,300 registered runners from 40 States and 27 countries, regions, and territories as they descended on...

Events

Press Releases

Triathlon

October 16, 2023

Showcased

Concept2 to Offer Kinomap Demonstrations at World’s Largest Regatta

BOSTON (Oct. 16, 2023) /ENDURANCE SPORTSWIRE/ - Kinomap is thrilled to announce that its groundbreaking interactive indoor training app for rowers will be available for demonstration at the Head of the Charles Regatta, taking place Oct. 20-22. The Concept2 demonstration area will be located in Attager Row: Rowing & Fitness...

Events

Press Releases

October 16, 2023

One For the Record Books: History Is Made at The First-Ever Women’s Only Vinfast IRONMAN World Championship in Kailua-Kona, Hawai`I

KAILUA-KONA, Hawai`i /ENDURANCE SPORTSWIRE/ - For the first time in IRONMAN’s 40+ year history, Kailua-Kona played host to a standalone women’s VinFast IRONMAN World Championship. Not only was this a moment for the record books, but history was also made on the course across both the women’s professional and age-group...

Events

Press Releases

Triathlon

October 16, 2023

Haley Batten and Keegan Swenson win inaugural Life Time Little Sugar MTB race to kick off Big Sugar Classic week

Bentonville/Bella Vista, Ark., (Oct. 15, 2023) /ENDURANCE SPORTSWIRE/ - Northwest Arkansas saw a stacked field of the world’s top mountain bike racers at the Life Time Little Sugar MTB, in which Haley Batten of Santa Cruz, Calif. and Keegan Swenson of Heber City, Utah took first in the elite 100K...

Cycling

Events

Press Releases

October 16, 2023

They Did It Again! Back-to-Back Win for Keulen and Simmonds at Challenge Peguera-Mallorca

/ENDURANCE SPORTSWIRE/ - It was a thrilling day of racing on the island of Mallorca with a new Challenge Peguera-Mallorca course record set by Youri Keulen (NED) and another convincing win for Imogen Simmonds (SUI), both taking back-to-back wins two weekends in a row. Both Keulen and Simmonds took the...

Events

Press Releases

Triathlon

October 15, 2023

Lucy Charles-Barclay (GBR) Soars atop Stellar Field to Become The 2023 Vinfast Ironman World Champion in Kailua-Kona, Hawai`I

KAILUA-KONA, Hawai`i  /ENDURANCE SPORTSWIRE/ - History was made today in Kailua-Kona, Hawai`i as the first-ever women’s-only VinFast IRONMAN World Championship unfolded on triathlon’s historic homeland, with Great Britain’s Lucy Charles-Barclay earning the crown in a perfectly executed performance. The female professional field featured defending and past IRONMAN World Champions, as...

Events

Press Releases

Triathlon