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

June 3, 2024

Moody and Hollioake take out Challenge Family Asia Pacific Championship at Challenge Gunsan-Saemangeum

/ENDURANCE SPORTSWIRE/ – Jesper Svenssen (SWE) led out the water in 51:04 with Guy Crawford (NZL) and Filipe Azevedo (POR) just one second apart 18 seconds down. Svenssen quickly asserted his dominance, pushing his lead out to over three minutes on Azevedo at the 40km mark. Crawford in third was...

Events

Press Releases

Triathlon

June 3, 2024

Guillem Montiel and Aurélia Boulanger Triumph at OTSO Challenge Salou

/ENDURANCE SPORTSWIRE/ – The men's race saw Kurt McDonald (AUS) take an early lead during the swim and extend it on the bike. However, Montiel's relentless pace on the run was the game-changer. McDonald, who had dominated the bike course with an impressive split of 1:49:26, finished a fraction of...

Events

Press Releases

Triathlon

June 3, 2024

Trakic Takes Win at Inaugural Challenge Gallipoli

/ENDURANCE SPORTSWIRE/ – In the swim it was Ognjan Stojanoviç (SRB) who took an early lead, exiting in the one-lap swim in historic ANZAC Cove in 23:17, a clear minute ahead of Trakic. However, a flat tire, just 1km into the bike put him over six minutes in deficit. Trakic...

Events

Press Releases

Triathlon

June 3, 2024

Rock ‘n’ Roll Running Series San Diego Runners are on the rise with more participating in Race Weekend year over year

- Runners went the distance this year with a 21 percent increase in marathoners from last year; Over 30,000 registered participants over the weekend - Rene Ortiz (Rioverde, Mexico) and Dakota Bliler (Scottsdale, Ariz.) were winners in the Rock ‘n’ Roll Running Series San Diego Marathon - Ayrton Ledesma (Azusa,...

Events

Press Releases

Triathlon

June 3, 2024

It’s Time to Climb! Climb 4 Climate Boston 2024 Inaugural Event Comes to Harvard Stadium on August 10, 2024

BOSTON, MA – June 3, 2024 /ENDURANCE SPORTSWIRE/ – Climb 4 Climate, a non-profit on a mission to fight climate change, today announced its inaugural stadium stair-climbing event will be held on Saturday, August 10, 2024, at iconic Harvard Stadium. Climate change is the existential crisis of our time. Millions...

Events

Giving

Press Releases

Running

June 3, 2024

TrainingPeaks Partners with AusCycling as Official Software Provider

Louisville, Colo., June 3, 2024 /ENDURANCE SPORTSWIRE/ - TrainingPeaks, the industry-leading training app for endurance coaches and athletes, today announced an exclusive partnership with AusCycling — the national sports organization responsible for the development, facilitation and growth of all forms of cycling and riding in Australia. Under the new agreement,...

Business

Press Releases

June 2, 2024

In Her First Full Distance Triathlon Since 2015, Jackie Hering (USA) Takes the Crown at the 2024 IRONMAN European Championship Hamburg

HAMBURG, Germany (June 2, 2024) /ENDIRANCE SPORTSWIRE/ - Hamburg today hosted the sixth IRONMAN Pro Series™ event of the year with the IRONMAN® European Championship for female professional triathletes. The race saw Jackie Hering (USA) crowned IRONMAN European Champion in her first full distance IRONMAN triathlon since 2015. Her epic...

Events

Press Releases

Triathlon

June 2, 2024

Life Time UNBOUND Gravel 2024 Crowns Finishers After an Epic Day in the Flint Hills

EMPORIA, Kan., (June 2, 2024) /ENDURANCE SPORTSWIRE/ - With over 4,000 riders representing all 50 states and 44 countries, Life Time UNBOUND Gravel 2024 marks the largest field size in the event’s history. The weekend commenced with the All-Things Gravel Expo presented by the City of Emporia, with hundreds of...

Cycling

Press Releases