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

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

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