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

November 14, 2024

IRONMAN Pro Series Start Lists Announced for the 2024 IRONMAN 70.3 Western Australia Asia-Pacific Championship

- IRONMAN 70.3 Western Australia Asia-Pacific Championship triathlon is the penultimate stop of the 2024 IRONMAN Pro Series calendar, and will offer a total event pro prize purse of USD $75,000 and 2,500 series points - Designated as the IRONMAN 70.3 Asia-Pacific Championship, the event will feature professional triathletes from...

Events

Press Releases

Triathlon

November 14, 2024

San Diego’s Iconic Santa Run Prepares for Record Breaking Year

Whether you’re running, cheering, or just looking for some holiday fun, the San Diego Santa Run has something for everyone SAN DIEGO — November 14, 2024 /ENDURANCE SPORTSWIRE/ - It’s almost time for one of San Diego’s most festive traditions—the San Diego Santa Run. With nearly 7,000 Santas ready to hit...

Events

Press Releases

Running

November 14, 2024

A Monumental Record-Breaking Day at the 2024 CNO Financial Indianapolis Monumental Marathon

INDIANAPOLIS /ENDURANCE SPORTSWIRE/ - More than 16,000 participants took on downtown Indianapolis this morning in the 17th annual CNO Financial Indianapolis Monumental Marathon, Half Marathon and 5K. The monumental day showcased a multitude of records, including three course records and an overall event record as the largest marathon ever. The Women’s...

Events

Press Releases

Running

November 14, 2024

2024 California International Marathon to Host Returning Champions and Paris Olympian

SACRAMENTO, Calif. /ENDURANCE SPORTSWIRE/ - The 41st California International Marathon’s elite field is set to run from Folsom to the California State Capitol on Sunday, December 8. The field is headlined by 2024 Paris Olympian Calli Hauger-Thackery and 2023 CIM Champion Cj Albertson. Hauger-Thackery and Albertson lead a group of...

Events

Press Releases

Running

November 13, 2024

Professional Triathletes Organisation Announce Frejus & St Raphael As Location For New French Riviera T100 Triathlon

London, UK (November 13th) /ENDURANCE SPORTSWIRE/ -  The Professional Triathletes Organisation (PTO) has confirmed the idyllic port towns of Frejus and St Raphaël will be the hub for the new French Riviera T100 Triathlon, when the world’s best triathletes come to the Côte d'Azur on 16-18 May next year. Billed...

Events

Press Releases

Triathlon

November 13, 2024

Ascension Seton Austin Marathon Welcomes PNC Bank as the 2025 Health and Fitness Expo Presenting Sponsor

Austin, TX – November 13, 2024 /ENDURANCE SPORTSWIRE/ – The 2025 Ascension Seton Austin Marathon, Half Marathon, & 5K® is excited to announce the Health and Fitness Expo is now presented by PNC Bank. Kicking off Presidents’ Day weekend, the Health and Fitness Expo will be held at the spacious...

Events

Press Releases

Running

Sponsorship

Trade Shows

November 13, 2024

Thousands of riders tackled 11th GFNY Cozumel

New York/ENDURANCE SPORTSWIRE/ - Thousands of riders from around the globe participated in the 11th edition of GFNY Cozumel, Latin America’s largest running cycling race. Riders tackled the 157.5 km challenging course under pouring tropical rain. Irrespective of the heavy rainfall, the race started off fast as always. Right from...

Cycling

Events

Press Releases

November 12, 2024

Enabled Tracking to Provide Live GPS Tracking for November 2024 Endurance Events

Front Royal, VA – November 2024 /ENDURANCE SPORTSWIRE/ – Enabled Tracking, a division of Adventure Enablers specializing in timing and tracking solutions, is excited to unveil its state-of-the-art live GPS tracking services. These advanced solutions will be available for both upcoming and ongoing endurance events. Designed to support participants as...

Business

Events

Press Releases