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

March 21, 2024

Patrick Lange and Magnus Ditlev – the fastest long-distance triathletes reunite in Roth in 2024

ROTH/ENDURANCE SPORTSWIRE/ – DATEV Challenge Roth on 7 July 2024 will once again be a world-class triathlon festival featuring the fastest athletes over the long distance, including Magnus Ditlev and Patrick Lange, who finished first and second last year. The fastest in the world 7:24:40 hours - that's all Magnus...

Events

Press Releases

Triathlon

March 21, 2024

All New Norco Fluid VLT E-MTB Blends Power and Lightweight Performance

PORT COQUITLAM, BC. /ENDURANCE SPORTSWIRE/ - In a year when many bike brands have slowed their pace, Norco continues to innovate and push the boundaries of bike design. Today, the brand is pleased to release the completely reimagined Carbon Fluid VLT E-MTB, now available at dealers and for order online...

Cycling

Press Releases

Products

March 21, 2024

Sold out GFNY Cannes opens Euro season

/ENDURANCE SPORTSWIRE/ – This Sunday, GFNY Cannes offers riders a spectacular 110.8 km race course with an elevation gain of 2011 m. The route leads from the shores of Cannes at the Côte d’Azur onto curvy and hilly hinterland roads with two significant climbs: Col du Tanneron with 7.5 km...

Cycling

Events

Press Releases

March 21, 2024

Route Announced for Juniors Racing 2024 USA Cycling Gran Fondo National Championships

(Gettysburg, PA – March 21, 2024) /ENDURANCE SPORTSWIRE/ - Gran Fondo National Series and USA Cycling today announced that Junior 14-16 Male and Female racers will compete for 2024 USA Cycling Gran Fondo National Championships on the 61-mile Medio Route of Gran Fondo Maryland on September 15, 2024. Junior 17-18...

Cycling

Events

Press Releases

March 21, 2024

Humango Partners with “From The Ground Up” For Season 4 of Epic Gravel Training

BOULDER, CO. (March 21, 2024)/ENDURANCE SPORTSWIRE/ – Humango™, a revolutionary training platform integrating AI-powered technology, is thrilled to announce their partnership with "From The Ground Up", a groundbreaking documentary series that chronicles the journeys of four novice athletes, tackling some of the toughest rides in the U.S. The collaboration marks a...

Cycling

Press Releases

Products

Sponsorship

March 21, 2024

Charge into Spring: Murf Electric Bikes Unleashes the Alpha ST

San Clemente, CA /ENDURANCE SPORTSWIRE/ – Murf Electric Bikes, a leading innovator in the e-bike industry, proudly introduces its latest addition to the lineup: the Alpha ST. This cutting-edge e-bike is set to redefine urban commuting and outdoor exploration with its unrivaled performance, more convenient access and sleek design. As the...

Press Releases

Products

March 20, 2024

Athlinks Surpasses 400 Million Results

[EVANSVILLE, IN] /ENDURANCE SPORTSWIRE/ - Athlinks, the premier destination for endurance athletes seeking to track their race results, proudly announces a monumental achievement: surpassing 400 million race results in its extensive database. This milestone not only cements Athlinks' position as the world's largest and most comprehensive results database for competitive...

Cycling

Events

Press Releases

Products

Running

Triathlon

March 20, 2024

America’s Noisiest Race Announcer Fitz Koehler Takes Center Stage in Dancing with the Stars Fundraiser

[Gainesville, FL March 20th, 2024] /ENDURANCE SPORTSWIRE/ - Fitz Koehler, renowned for her vibrant presence and happy noise in the racing world, is set to dazzle audiences in a different arena as she participates in a special edition of Dancing with the Stars. The event, organized as a Dance Alive...

Events

Giving

Press Releases

March 20, 2024

Asconeguy and García win GFNY Uruguay-Punta del Este

New York City, March 20, 2024 /ENDURANCE SPORTSWIRE/ – Punta del Este hosted the sixth edition of GFNY Punta del Este this past Sunday. The long racecourse was 146 km with an elevation gain of 1654 m. Under perfect late summer weather conditions, the race started off fast at Playa...

Cycling

Events

Press Releases