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 (8742)
) 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 80, 10

December 13, 2024

How To watch: 2024 VinFast IRONMAN 70.3 World Championship in Taupo, New Zealand

TAUPŌ, New Zealand (Dec 13, 2024) /ENDURANCE SPORTSWIRE/ — The 2024 VinFast IRONMAN® 70.3® World Championship triathlon will make its long-anticipated stop in Taupō, New Zealand this weekend. The two days of racing will feature nearly 100 of the world’s best professional athletes and approximately 6,200 registered age-group athletes as...

Events

Press Releases

Triathlon

December 13, 2024

Big Sur International Marathon Announces HOKA as Presenting Sponsor in Multi-Year Agreement

CARMEL, CA (December 13, 2024) /ENDURANCE SPORTSWIRE/ – The Big Sur International Marathon welcomes long-time partner HOKA as its new presenting sponsor for the 38th annual event set to take place on April 27, 2025. This 5-year partnership builds upon HOKA’s longstanding relationship with the marathon and expands on their...

Events

Press Releases

Running

Sponsorship

December 13, 2024

Ready for the Open Water: Sumarpo Cold Open Water Kits and Accessories Review

December 13, 2024 /ENDURANCE SPORTSWIRE/ - For those brave enough to embrace the challenge of open water swimming, Sumarpo has launched a comprehensive range of cold-water swimming essentials designed to keep athletes safe, comfortable, and performing at their best, no matter the conditions. Sumarpo Openwater Wetsuit: Unmatched Comfort and Flexibility...

Press Releases

Products

December 12, 2024

Game On Sports & Performance Center Partners with 360 Hoops to Introduce a Revolutionary New Sport to Massachusetts

Fitchburg, MA – December 12, 2024 /ENDURANCE SPORTSWIRE/ - Game On Fitchburg is proud to announce a market-exclusive partnership with 360 Hoops™, being the first to bring the innovative game to New England. Played on a circular court, 360 Hoops blends the spirit of traditional basketball with a dynamic twist....

Business

Events

Press Releases

Products

December 12, 2024

Los Angeles Marathon Partners with Badges and Medals to Launch Sustainable Medal Program

LOS ANGELES – December 12, 2024 /ENDURANCE SPORTSWIRE/ – The Los Angeles Marathon presented by ASICS proudly announces Badges And Medals as the Official Medal Partner and a supporting sponsor of its Sustainability Program, ahead of the milestone 40th annual event on Sunday, March 16, 2025. “We are thrilled to...

Events

Press Releases

Running

Sponsorship

December 12, 2024

P3R Announces Neversecond as Official Nutrition Partner, Launching Education Series and Marathon Starter Packs

[Pittsburgh, PA – December 12, 2024] /ENDURANCE SPORTSWIRE/ – P3R is excited to announce a new partnership with Neversecond, a leading sports nutrition company, as the Official Nutrition Partner of all P3R events in 2025. This collaboration is set to enhance the experience of runners at every level, offering both...

Press Releases

Products

Running

Sponsorship

December 12, 2024

New Host for 2025 XTERRA Euro Champs & Youth Euro Champs Debut

ZITTAU, GERMANY /ENDURANCE SPORTSWIRE/ — Now in its 29th year since pioneering off-road triathlon from the shores of Maui, Hawaii, XTERRA continues to expand the sport across the globe with a major announcement for the upcoming host location of the 2025 XTERRA European Championship. The weekend of August 15-17, 2025,...

Cycling

Events

Press Releases

Running

Triathlon

December 12, 2024

Course Records Shattered at 41st California International Marathon

SACRAMENTO, Calif. /ENDURANCE SPORTSWIRE/ – Both the men’s and women’s course records were shattered on Sunday at the 41st running of the California International Marathon (CIM). On the men’s side, Tsegay Weldlibanos, who is originally from Eritrea and now competes internationally as an asylum athlete, broke the tape in 2:07:35,...

Events

Press Releases

Running