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

February 5, 2024

IRONMAN Global Athletes’ Choice Awards Announced For 2023 IRONMAN and IRONMAN 70.3 Triathlons

The winner's videos can be viewed here: Qatar Airways IRONMAN France Nice IRONMAN 70.3 Zell am See-Kaprun TAMPA, Fla. (Feb 5, 2024) – IRONMAN today announced the IRONMAN® and IRONMAN 70.3® Athletes’ Choice Awards winners, highlighting the highest-scoring events in a variety of categories based on athletes’ post-event surveys from...

Awards

Events

Press Releases

Triathlon

February 4, 2024

2024 Cyclocross World Championships Concludes With Three Americans in the Top 20

TÁBOR, Czech Republic /ENDURANCE SPORTSWIRE/ - Sunday concluded with the Junior Men, U23 Women, and Elite Men at the 2024 UCI Cyclocross World Championships. Sixteen athletes represented Team USA on the world stage, with three individuals finishing in the top 20 of their respective categories. Junior Men David Thompson (New Canaan,...

Cycling

Events

Press Releases

February 3, 2024

Lopez de San Roman Earns Top Position for Team USA at 2024 Cyclocross World Championships

TÁBOR, Czech Republic /ENDURANCE SPORTSWIRE/ - The 2024 UCI Cyclocross World Championships continued Saturday with the Junior Women, U23 Men, and Elite Women. Team USA arrived on site ready to take on the muddy course. After the Junior Women’s race, the conditions changed dramatically, which resulted in many of the...

Cycling

Events

Press Releases

February 2, 2024

Team USA Kicks off 2024 Cyclocross World Championships in Tabor

TÁBOR, Czech Republic /ENDURANCE SPORTSWIRE/ - The team relay event kicked off the 2024 Cyclocross World Championships in Tabor, Czech Republic today. The course conditions were unpredictable with an icy frozen base, then a thin layer of slick mud on top. It left the riders on their toes while they...

Cycling

Events

Press Releases

February 2, 2024

Salinas – Ecuador Set to Host New 5150 Triathlon

- Organizers of the Marathon IRONMAN 70.3 Ecuador to host La Roche Posay 5150 Salinas Ecuador triathlon presented by Marathon scheduled to take place on Sunday, May 5, 2024; Registration is now available by visiting www.ironman.com/5150-salinas QUITO, Ecuador / TAMPA, Fla. (February 2, 2024) /ENDURANCE SPORTSWIRE/ – IRONMAN announced today that the...

Events

Press Releases

Triathlon

February 2, 2024

Showcased

Monuments of Cycling Announces New Partnership with Canyon Bicycles for 2024 Belgian Waffle Ride’s Triple Crown of Gravel Series

SAN DIEGO /ENDURANCE SPORTSWIRE/ – Monuments of Cycling (MoC), the renowned producer of the iconic Belgian Waffle Ride (BWR), is delighted to unveil its partnership with Canyon Bicycles as the Official Bike Sponsor of the Tripel Crown of Gravel Series. Canyon will seize the opportunity presented by the three early...

Cycling

Events

Press Releases

Sponsorship

February 1, 2024

Women’s Triathlon Events Expand In Carolinas

February 1, 2024. Mt. Pleasant, SC /ENDURANCE SPORTSWIRE/ – Charleston based She Tris Triathlon events announced this week an agreement with Jeremey Davis of Set Up Events to purchase and rebrand the NC based all women triathlon events, known as Ramblin’ Rose. The NC series started in 2007 and has events throughout...

Business

Events

Press Releases

Triathlon