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

June 12, 2024

IRONMAN Pro Series Start Lists Announced for The 2024 IRONMAN 70.3 Mont-Tremblant Triathlon

- The IRONMAN 70.3 Mont-Tremblant triathlon offers a maximum of 2,500 points towards IRONMAN Pro Series standings and a $50,000 event total pro prize purse - 2022 IRONMAN World Champion and 2024 IRONMAN New Zealand Champion, Chelsea Sodaro (USA) set to make her IRONMAN Pro Series debut - IRONMAN Pro...

Events

Press Releases

Triathlon

June 12, 2024

Climb 4 Climate Appoints Premier Event Management Firm DMSE Sports for Inaugural Boston Event at Harvard Stadium

BOSTON, MA - June 12, 2024 /ENDURANCE SPORTSWIRE/ – Climb 4 Climate, a non-profit organization on a mission to fight climate change with stadium stair-climbing events, today announced its partnership with DMSE Sports, a leading event management, logistics, and operations firm, for the inaugural Climb 4 Climate Boston event being held...

Business

Events

Press Releases

June 12, 2024

Lindsay takes the sprint finish and Arévalo a solo win at GFNY Paracas – Perú

New York City /ENDURANCE SPORTSWIRE/ – Paracas hosted the first 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 started off fast with speeds hitting well over 50km/h. After hectic and aggressive racing, it...

Cycling

Events

Press Releases

June 12, 2024

Taylor Knibb Imperious In Winning San Francisco T100

San Francisco, USA /ENDURANCE SPORTSWIRE? - American Taylor Knibb was dominant in winning the San Francisco T100 today on the iconic Escape From Alcatraz Triathlon course today. She was second out of the water, but quickly took the lead on the bike from Switzerland’s Imogen Simmonds and went on to register...

Events

Press Releases

Triathlon

June 12, 2024

Marten Van Riel Wins San Francisco T100 In Three-Way Sprint To The Line

San Francisco, USA /ENDURANCE SPORTSWIRE/ - Belgium flier Marten Van Riel outsprinted New Zealand’s Kyle Smith and Germany’s Rico Bogen to claim his maiden T100 victory on the Escape From Alcatraz course in San Francisco in dramatic fashion today. Van Riel is now unbeaten in five long course races out of...

Events

Press Releases

Triathlon

June 11, 2024

Introducing GranFondo Riviera Nayarit

Riviera Nayarit, Mexico /ENDURANCE SPORTSWIRE/ - Cycling enthusiasts around the globe have a new reason to celebrate. The team behind the world-renowned RBC GranFondo Whistler is proud to announce the launch of GranFondo Riviera Nayarit, set to take place on April 5, 2025, in the stunning region of Riviera Nayarit, Mexico....

Business

Cycling

Events

Press Releases

June 10, 2024

Shimano Returns as Official Technical Support Partner for 2024 Chicago Grit

Chicago, IL – June 10, 2024 /ENDURANCE SPORTSWIRE/ - Chicago Grit, formerly known as the Intelligentsia Cup, is proud to announce that Shimano is returning as the Official Technical Support Partner for the 2024 race series. This marks Shimano's fourth year in this critical role, underscoring their unwavering dedication to...

Business

Cycling

Events

Press Releases

Products

Sponsorship

June 10, 2024

Life Time Rad Dirt Fest Now an Official 2025 Life Time UNBOUND Qualifier

TRINIDAD, Co., (June 10, 2024) /ENDURANCE SPORTSWIRE/ – Following a successful 2024 Life Time UNBOUND Gravel, Life Time – the owner and producer of nearly 30 iconic athletic events – has announced that Life Time’s The Rad Dirt Fest, will be an official qualifying event for the Life Time UNBOUND...

Cycling

Events

Press Releases