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

June 13, 2025

IRONMAN Announces Partnership with ESPN to Bring Live Coverage of the IRONMAN Pro Series to Latin America and the Caribbean

TAMPA, Fla, (June 13, 2025) /ENDURANCE SPORTSWIRE/ – IRONMAN, the global leader in long-distance triathlon, and ESPN, the world's leading multiplatform sports entertainment brand, have today announced a broadcast partnership exclusively for viewers in Latin America and the Caribbean. The deal will see ESPN’s digital platform within Disney+ showcase all...

Business

Events

Press Releases

Triathlon

June 13, 2025

Movemint Launches New Photos Feature to Bring Race Day Memories to Life

SAN FRANCISCO, CA [6/13/2025] /ENDURANCE SPORTSWIRE/ - Movemint, a technology platform for endurance events, has released a new Photos feature that allows event organizers and photographers to upload and share photo albums directly on the event page, giving participants a seamless way to relive their race day experience. Whether it’s...

Business

Events

Press Releases

Products

June 12, 2025

World-Class Start List Revealed for the 2025 Mainova IRONMAN Frankfurt European Championship Triathlon

Three IRONMAN World Champions to go head to-head as current World Champion, Patrick Lange (DEU) and 2024 European Champion, Kristian Blummenfelt (NOR) return to Frankfurt, while 2022 IRONMAN World Champion Gustav Iden (NOR) is set to make his debut in the city Last year’s IRONMAN World Championship runners up –...

Cycling

Events

Press Releases

Running

June 12, 2025

L’Alpe d’Huez this Sunday at GFNY La Vaujany

New York City, June 12, 2025 /ENDURANCE SPORTSWIRE/ - This Sunday, the picturesque mountain village of Vaujany in the French Alps will once again welcome riders from around the world for the fifth edition of GFNY La Vaujany, a race known for its breathtaking scenery and unforgiving climbs. The 151...

Cycling

Events

Press Releases

June 11, 2025

HOKA UTMB Mont-Blanc Commits To a 20% Reduction in Carbon Emissions by 2030 and Unveils an Ambitious Plan to Promote Sustainable Mobility

Commitment to cut HOKA UTMB Mont-Blanc’s carbon emissions by 20% by 2030, based on the event’s 2024 carbon footprint Focus on transport: 30% lottery bonus for runners choosing recommended lowest carbon travel options Launched UTMB GO – a dedicated platform to support sustainable travel to the event Further details to...

Events

Giving

Press Releases

Running

June 11, 2025

2025 XTERRA Nouvelle Aquitaine Returns to the Wild

BEAUMONT-DU-LAC, FRANCE (June 11, 2025) /ENDURANCE SPORTSWIRE/ – From June 13-14, 2025, XTERRA Nouvelle Aquitaine returns to Lac de Vassivière for its second year at this scenic venue and sixth edition overall. Nestled in the pine-covered highlands of central France, the race blends exploration, tradition, and a deep sense of...

Events

Press Releases

Triathlon

June 11, 2025

Sprint finish at GFNY Paracas – Peru

New York City, June 11, 2025 /ENDURANCE SPORTSWIRE/ - Paracas hosted the second edition of the GFNY Paracas this past Sunday. The challenging race course was 116 km long with an elevation gain of 662 m. The race kicked off at a fast pace, with speeds exceeding 50 km/h. The...

Cycling

Events

Press Releases