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

July 3, 2023

EKOÏ and Pininfarina Unveil The Aerodinamica Helmet

/ENDURANCE SPORTSWIRE/ - Cycling equipment brand Ekoï is proud to present its new Aerodinamica helmet on the day of the big start of the Tour de France. More than just a name, the Aerodinamica reflects the very essence of its design, with a reference to the history of the designers...

Cycling

Events

Press Releases

Sponsorship

Triathlon

July 3, 2023

USA Cycling Announces 2023 Track World Championship Teams

COLORADO SPRINGS, Colo./ENDURANCE SPORTSWIRE/ – The 2023 UCI Cycling World Championships will make history in Glasgow, Scotland, as the first World Championship where 13 events will be contested across seven disciplines. 15 athletes will compete in the Track events on August 3-9, 2023, at the Sir Chris Hoy Velodrome. The team’s focus this...

Cycling

Events

Press Releases

July 3, 2023

National Cycling League Announces Updates and Final Schedule for The Inaugural NCL Cup Series

/ENDURANCE SPORTSWIRE/ - The fourth NCL Cup race—originally scheduled for September 17 in Washington D.C.—has been removed from the original four-race series. The National Cycling League (NCL), the first-of-its-kind professional cycling league, has announced that the remaining two races in the NCL Cup Series will include NCL Cup Denver (August...

Cycling

Events

Press Releases

Sponsorship

Triathlon

July 2, 2023

Arthur Forissier, Sandra Mairhofer win XTERRA France

/ENDURANCE SPORTSWIRE/ - Arthur Forissier (FRA) and Sandra Mairhofer (ITA) captured the 16th annual XTERRA France off-road triathlon elite titles in Xonrupt on Sunday, July 2, 2023 with winning times of 3:03:53 and 3:26:16, respectively. It’s the ninth career XTERRA World Tour win for Forissier and the sixth for Mairhofer....

Events

Press Releases

Triathlon

July 2, 2023

Matthew Guenter (Boulder, Colo.) And Caroline Moyer (Malvern, Pa.) Claim Victories in Debut of IRONMAN 70.3 Pennsylvania Happy Valley Triathlon

HAPPY VALLEY, Pa. (July 2, 2023) /ENDURANCE SPORTSWIRE/ - Central Pennsylvania’s beautiful landmarks and stunning scenery played host to the inaugural edition of IRONMAN® 70.3® Pennsylvania triathlon on Sunday, July 2. Participating athletes were treated to an IRONMAN 70.3 journey through Happy Valley and the iconic Penn State University campus...

Events

Press Releases

Triathlon

July 2, 2023

Hat Trick for Funk and Win for Simmonds at Challenge Kaiserwinkl-Walchsee

/ENDURANCE SPORTSWIRE/ - It was a three-peat for Frederic Funk (GER) at today’s Challenge Kaiserwinkl-Walchsee, taking the hat trick at his hometown race in 3:41:20. Imogen Simmonds (SUI) took out the women’s title after changing the race on the run in 4:13:42. Sven Thalmann (SUI) led a group of three...

Events

Press Releases

Triathlon

July 2, 2023

Matt Trautman and Anna Bergsten dominant at Challenge Vansbro

/ENDURANCE SPORTSWIRE/ - South African Matt Trautman and Swedish Anna Bergsten won Challenge Vansbro in dominant style today. The race was hard fought during the bike and finally decided during the run. Trautman won the race 3:34:59 and Bergsten in 4:10:02. In the men’s race, it was initially Norwegian Jorgen...

Events

Press Releases

Triathlon

June 30, 2023

Champion U.S. Vibram Athlete Summits Denali

“Her Denali Speed Project” focused on empowering women in mountain sports /ENDURANCE SPORTSWIRE/ – Meredith Edwards, a US mountain endurance athlete and member of Team Vibram spent just over a month on Denali pushing for the women’s FKT and summited this month. Bad weather on many days hampered her FKT but...

Press Releases

Sponsorship

June 30, 2023

UTMB® Mont-Blanc 2023: new initiatives and more CSR innovations

/ENDURANCE SPORTSWIRE/ – Since its creation in 2003, UTMB® Mont-Blanc has operated based on fundamental principles of fairness, respect, mutual aid, solidarity and respect for the fragile Mont Blanc ecosystem. From the outset, UTMB® Mont-Blanc initiated a collaboration with the ‘Association des Amis de l'UTMB® Mont-Blanc’ [1] to ensure the fair...

Events

Press Releases