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

June 17, 2025

International Field Set for Action at LOTTO Challenge Gdansk

June 17, 2025 /ENDURANCE SPORTSWIRE/ - This Sunday, the city of Gdańsk will once again welcome an elite lineup of international talent for Lotto Challenge Gdańsk, with 23 professional athletes confirmed to race along Poland’s Baltic coast. The 2025 edition continues to build its reputation as a premier middle-distance event,...

Events

Press Releases

Triathlon

June 17, 2025

Upham, Dumas, and Dominant Youth Impress at 2025 XTERRA Nouvelle Aquitaine

June 17, 2025 /ENDURANCE SPORTSWIRE/ - XTERRA Nouvelle Aquitaine returned to the highlands of central France for its sixth edition on June 13–14, 2025, set against the pine forests and ancient trails surrounding Lac de Vassivière. It was the second year at this nature-rich vacation destination, where the off-road triathlon...

Events

Press Releases

Triathlon

June 16, 2025

SAIL Challenge Québec powered by Argon 18 Brings Long Distance Triathlon Back to Québec

Québec City (June 16, 2025) /ENDURANCE SPORTSWIRE/ - SAIL Challenge Québec powered by Argon 18 will mark the long-awaited return of long distance triathlon to the province of Québec on 28 June 2026, after a three-year hiatus. Thanks to an exclusive partnership with the prestigious DATEV Challenge Roth – the...

Events

Press Releases

Triathlon

June 16, 2025

Game On: The Boston Run & Outdoor Expo Moves to Gillette Stadium

June 16, 2025 /ENDURANCE SPORTSWIRE/ - After industry consultation and visitor feedback, The Boston Run and Outdoor Expo announces its new home at Gillette Stadium in Foxborough, Massachusetts, March 28-29 2026. The move reunites the Boston Run and Outdoor Expo under one roof once more—this time at a world-class venue...

Events

Press Releases

June 16, 2025

California International Marathon Selected to Host 2025 and 2026 USATF Marathon Championships

Sacramento, Calif. (June 16, 2025) /ENDURANCE SPORTSWIRE/ - The California International Marathon (CIM) has been selected to host the 2025 and 2026 USA Track & Field (USATF) Marathon Championships by the USATF Long Distance Running Committees. The 2025 Championships will take place on Sunday, December 7, held in conjunction with...

Events

Press Releases

Running

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