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

July 5, 2023

L’Alpe d’Huez climb protagonist at GFNY La Vaujany

New York City, July 5, 2023 /ENDURANCE SPORTSWIRE/ - The alpine mountain village of Vaujany hosted the third edition of GFNY La Vaujany this past Sunday. The racecourse was 151 km long with an elevation gain of 3914 m and included the legendary climb of L’Alpe d’Huez among other cols....

Cycling

Events

Press Releases

July 5, 2023

US Adventure Race National Championship coming to Vermont

/ENDURANCE SPORTSWIRE/ - The United States Adventure Racing Association National Championship is coming to Vermont September 15-16, 2023. Based out of Smugglers’ Notch Resort in Jeffersonville, the race has teams of three paddling, swimming, mountain biking, and trekking for 30 hours non-stop through the Green Mountains. The course is top...

Events

Press Releases

July 4, 2023

Pho3nix Foundation Reaches Milestone

/ENDURANCE SPORTSWIRE/ - At the halfway point in 2023, Pho3nix Kids continues to break new ground and reach more children, supporting the Pho3nix Foundation’s goals to bring sport to kids all over the world – more than half a million participants in four years across eight countries. In Poland, Pho3nix...

Giving

Press Releases

Sponsorship

July 4, 2023

The Tahoe Rim Trail Run provides live tracking in 2023

Front Royal, Va./ENDURANCE SPORTSWIRE/ - The Tahoe Rim Trail Run will be providing live tracking in 2023, thanks to Enabled Tracking. The event is scheduled for July 15, and will begin and end at the Western Nevada College in Carson City, Nevada. Participants will complete either a 100 mile, 50...

Events

Press Releases

Products

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