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

October 9, 2025

IRONMAN and Hawai`i: A Special Bond Founded on the Importance of Community Connection, Living Aloha, and Celebrating Human Achievement

- Live Aloha initiative encourages all those attending, visiting, and participating in the 2025 IRONMAN World Championship in Kailua-Kona to respect, connect with, and celebrate the Hawaiian culture, lands, and people - Family, friends, spectators and the entire Hawai`i community encouraged to celebrate the amazing accomplishments of the world’s best...

Events

Press Releases

Triathlon

October 9, 2025

Copperfield 5K Cold Run 2025 Debuts Color-Changing Medal

October 7, 2025 /ENDURANCE SPORTSWIRE/ - The Copperfield 5K Cold Run, set for October 11, 2025 in Louisville, KY, is adding extra excitement to this year’s event with a color-changing finisher medal designed and produced by X T-shirt. Medal Tells the Story The medal, shaped like a house to reflect...

Events

Press Releases

Products

Running

October 8, 2025

Record-Breaking Supertri Chicago Triathlon Delivers USD 17.5M Economic Impact and Sells Out Early Bird Registration for 2026 at Highest-Ever Levels

CHICAGO, IL (October 8, 2025) /ENDURANCE SPORTSWIRE/ – Following the record-breaking Supertri Chicago Triathlon held on August 23–24, early bird registration for the 2026 Chicago Triathlon has closed at the highest level in the event’s history – double the figure achieved in 2024. The 42nd annual Supertri Chicago Triathlon, once again...

Business

Events

Press Releases

Studies

Triathlon

October 8, 2025

25th Anniversary to Host 13,500 Runners

Baltimore, MD (October 8, 2025) /ENDURANCE SPORTSWIRE/ - Corrigan Sports Enterprises (CSE) announced today that a projected 13,500+ runners will converge on the City of Baltimore on Saturday, October 18th for the 25th annual Baltimore Running Festival. The festival has attracted runners from all 50 states and 26 foreign countries...

Events

Press Releases

Running

October 8, 2025

Registration Now Open for Pittsburgh Parade Day Dash Presented by GNC

PITTSBURGH, PA (October 8, 2025) /ENDURANCE SPORTSWIRE/ –Grab your green gear and running shoes—registration is officially open for the second annual Pittsburgh Parade Day Dash presented by GNC! This festive, family-friendly tradition returns on Saturday, March 14, 2026, giving participants the chance to kick off Parade Day with a 5K...

Events

Press Releases

Running

October 8, 2025

Sold-Out Field Lines Up for Challenge Vieux Boucau

October 8, 2025 /ENDURANCE SPORTS/- Over 2,200 athletes will line up at the sold-out Challenge Vieux Boucau on 11 October, including an impressive field of 85 professional athletes. With many top names returning to form and several new contenders joining, both the men’s and women’s races promise world-class competition on...

Events

Press Releases

Triathlon

October 8, 2025

Motiv Sports partners with findarace.com to reach new runners

October 8, 2025 /ENDURANCE SPORTSWIRE/ - Findarace.com, the race calendar and event marketing platform, has announced a new partnership with Motiv Sport event company. The US’s most popular race calendar, findarace.com will work with Motiv on the Savannah Southern Half, to increase the event’s visibility amongst the platform’s audience of millions...

Business

Events

Press Releases

Running