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

March 21, 2024

P3R Announces “America’s Mile” — A Revitalized Running Tradition Set to Take the Country by Storm on July 12

PITTSBURGH, PA (March 21, 2024) /ENDURANCE SPORTSWIRE/ – P3R, the engine behind Pittsburgh's most iconic road races, is thrilled to unveil "America's Mile," the latest evolution of the city's beloved one-mile challenge, now poised to become a national sensation. Presented by VisitPITTSBURGH, the event is scheduled to dazzle participants and...

Events

Press Releases

Running

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

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 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

March 20, 2024

“The goal is to win Roth” – Laura Philipp returns to Roth in 2024

ROTH/ENDURANCE SPORTSWIRE/ – German long-distance triathlon record holder, Laura Philipp, will be competing again at DATEV Challenge Roth on 7 July 2024. The 36-year-old is returning to the Home of Triathlon after her third place in Roth last year. "Would like to perform even better" Laura Philipp has a very...

Events

Press Releases

Triathlon