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

June 28, 2023

Safa Brian Announces “Tour to The Tour”

/ENDURANCE SPORTSWIRE/ – Safa Brian, cyclist and filmmaker, announced in a video on his YouTube channel today that he and two of his talented friends—Alex Colorito (videographer) and Taylor Dawson (cyclist)—are departing on Saturday, July 2nd, for a European bike adventure. Over ten days, the crew will enjoy a route that...

Cycling

Events

Press Releases

June 27, 2023

2023 IRONMAN 70.3 Mont-Tremblant Triathlon Rescheduled to take place on August 20 in conjunction with the full distance IRONMAN Mont-Tremblant Triathlon, part of the VinFast IRONMAN North America Series

MONT-TREMBLANT, QUEBEC, CANADA (June 27, 2023)/ENDURANCE SPORTSWIRE/ – IRONMAN and Tremblant Resort are pleased to announce that the IRONMAN® 70.3® Mont-Tremblant triathlon has been rescheduled for Sunday, August 20, 2023. The event, which was originally scheduled to take place on Sunday, June 25 was cancelled due to the devastating wildfires that...

Events

Press Releases

Triathlon

June 27, 2023

Arena Games Triathlon Stars at Olympic Esports Week

/ENDURANCE SPORTSWIRE/ – Arena Games Triathlon dazzled on the world stage as the unique race format made its debut at the Olympic Esports Week in Singapore. The multi award-winning real life and virtual hybrid concept from Super League Triathlon continued its impressive rise and had the chance to impress at the...

Events

Press Releases

Triathlon

June 27, 2023

Join the Ride: Bike Fest 2023 Brings Cycling, Community, and Celebration to Asheville, NC

Asheville, NC, June 27, 2023 /ENDURANCE SPORTSWIRE/ - Asheville on Bikes (AoB) is thrilled to announce the return of the much-anticipated 2nd annual Bike Fest, presented by Cane Creek Cycling Components. The event kicks off in Asheville on Friday, July 14, and runs through Saturday, July 15. The Gran Fondo Asheville...

Business

Cycling

Events

Press Releases

Sponsorship

June 26, 2023

USA Blind Soccer National Team Hosting Clinics at Angel City Games

(June 26, 2023) /ENDURANCE SPORTSWIRE/ - The U.S. Association of Blind Athletes (USABA) is hosting two blind soccer clinics on Sunday, July 2, as part of the 2023 Angel City Games. The clinics will be conducted by members of the USA Blind Soccer Men’s National Team at the University of...

Events

Press Releases

June 26, 2023

Stellar line up planned for 2023 50-mile time trial championships

26th June 2023, UK/ENDURANCE SPORTSWIRE/ – Kate Allan (Team Bottrill) defends her women’s title won last year in the Northeast. Hayley Simmonds (AWOL O’Shea) will be a likely challenger to Allan. Hayley was out for most of last year after surgery to correct an iliac artery issue and will be more...

Cycling

Events

Press Releases

June 26, 2023

Challenge Kaiserwinkl-Walchsee promises fireworks this weekend

/ENDURANCE SPORTSWIRE/ – As a local, Funk knows the race like no other: he regularly trains on the alpine course as he lives just a stone's throw away. With already two wins to his name, there are few races where he likes to win as much as Challenge Kaiserwinkl-Walchsee. Still, he...

Events

Press Releases

Triathlon

June 26, 2023

Chris Leiferman (USA) and Jodie Robertson (USA) Claim Victories At 2023 IRONMAN Coeur d’Alene Triathlon, Part of The Vinfast IRONMAN North America Series

COEUR D’ALENE, Idaho /ENDURANCE SPORTSWIRE/ - The scenic Northern Idaho and the city of Coeur d’Alene celebrated 20 years of racing with the return of the IRONMAN® Coeur d’Alene triathlon, part of the VinFast IRONMAN North America Series, on Sunday, June 25. With some of triathlon’s best on hand, Chris...

Events

Press Releases

Triathlon

June 26, 2023

Record Day in Roth

/ENDURANCE SPORTSWIRE/ - ROTH. It was a day of superlatives at DATEV Challenge Roth powered by hep: Magnus Ditlev (DEN) defended his title in a new world best time of 7:24:40, Daniela Ryf (SUI) beat the twelve year old world best time of Chrissie Wellington by almost ten minutes. In...

Events

Press Releases

Triathlon