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

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

June 11, 2025

Gran Fondo Asheville and Applewood Manor Foundation Collaborating to Raise Funds for Asheville’s River Arts District Artists Foundation (RADA)

Gettysburg, PA (June 11, 2025) /ENDURANCE SPORTSWIRE/ - For the 13th year, Gran Fondo National Series will host the Gran Fondo Asheville, presented by Applewood Manor Foundation, cycling event in Asheville, North Carolina on Sunday, July 20, 2025. Pre-race festivities, including Donor Appreciation Events hosted by Applewood Manor Foundation and...

Cycling

Events

Giving

Press Releases

Sponsorship

June 11, 2025

Paula Findlay Looks Forward To Racing On Home Turf At Vancouver T100 Triathlon

Vancouver, Canada (June 11, 2025) /ENDURANCE SPORTSWIRE/ -  Canadian favourite Paula Findlay cannot wait to race on home soil again as she looks forward to this Saturday’s Vancouver T100 Triathlon on 14-15 June. Buoyed by an encouraging fourth position in the San Francisco T100 10 days ago on 31 May,...

Events

Press Releases

Triathlon