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

May 7, 2024

Broken Arrow Skyrace Partners with Sister Race DDM Trail and Run the Alps

Olympic Valley, CA /ENDURANCE SPORTSWIRE/ – The message at the Broken Arrow Skyrace is "whether you finish first or last, YOU are a rockstar." This ethos is core to the identity of the three-day, nine-distance event held at Palisades Tahoe each June, and is paramount to the type trail running...

Business

Events

Press Releases

Running

May 6, 2024

Serrières and Riou Conquer the Elements at XTERRA Nouvelle Aquitaine

BEAUMONT-DU-LAC, FRANCE /ENDURANCE SPORTSWIRE/ – On May 4th, 2024, the fifth edition of XTERRA Nouvelle Aquitaine delivered an unforgettable race day, described by many as both wild and crazy. Arthur Serrières (FRA), current XTERRA World Cup Champion, triumphed for the fourth time at his local race, while Morgane Riou (FRA)...

Cycling

Events

Press Releases

Running

Triathlon

May 6, 2024

Paris 2024 Olympic Qualification on the Line for U.S. Elite Triathletes in Yokohama

COLORADO SPRINGS, Colo./ENDURANCE SPORTSWIRE/ – U.S. elite triathletes will compete for U.S. Olympic Triathlon Team selections on Saturday, May 11 at the 2024 World Triathlon Championship Series Yokohama. The women’s and men’s races are the final opportunity for U.S. elite triathletes to auto-qualify for the Olympic Games Paris 2024. In addition...

Events

Press Releases

Triathlon

May 6, 2024

Registration for the 2025 Ascension Seton Austin Marathon Officially Opens May 13, 2024

AUSTIN, Texas, May 6, 2024 /ENDURANCE SPORTSWIRE/ – Registration for the 2025 Ascension Seton Austin Marathon, Half Marathon & 5k ® officially opens Tuesday, May 13th. To mark the opening, there will be a week-long celebration that includes giveaways, promotions, group runs, and social gatherings. In addition, for each registration...

Events

Press Releases

Running

May 5, 2024

Sam Long (USA) Repeats While Paula Findlay (CAN) Tops the Field at the 2024 Intermountain Health IRONMAN 70.3 North American Championship St. George Triathlon

ST. GEORGE, Utah /ENDURANCE SPORTSWIRE/ - Stunning St. George and Southwestern Utah played host to the 2024 Intermountain Health IRONMAN® 70.3® North American Championship St. George triathlon today, doubling as the third race of the IRONMAN Pro Series™. The race saw Sam Long (USA) repeat as a winner in St...

Events

Press Releases

Triathlon

May 3, 2024

Tomas Rodriguez Runs Away with April PTO Athlete of The Month

London, UK/ENDURANCE SPORTSWIRE/ – Tomas Rodriguez’s incredible performance at Ironman Texas has also landed him the top step for April’s PTO Athlete of the Month, in a month full of stand-out performances. The spring-heeled Mexican obliterated the run course record in The Woodlands, with his split of 2:34:14 was the fastest...

Awards

Events

Press Releases

Triathlon

May 3, 2024

The Adventure Continues! Secure Your Spot for the Epic TCC 2025!

Costa Rica, May 2, 2024 /ENDURANCE SPORTSWIRE/ - The Coastal Challenge (TCC) Costa Rica, the premier endurance race that has captivated adventurers from around the globe, is excited to announce that registrations for its monumental 21st edition, set to take place in 2025, are officially open. This announcement comes on...

Events

Press Releases

Running

May 3, 2024

Lilac Bloomsday Run 12K Hosts 27th PRRO Championship

SPOKANE, WA /ENDURANCE SPORTSWIRE/ – The 27th PRRO Championship presented by the Lilac Bloomsday Run 12K will be contested on Sunday morning, May 5, and at the 48th race edition, a top international field will be vying for the $81,000 in prize money, including $20,000 U.S. prize money and $7000...

Events

Press Releases

Running