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

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

March 20, 2024

New Zealand pro team racing Gran Premio New York City

NEW YORK CITY, March 20, 2024 /ENDURANCE SPORTSWIRE/ – The inaugural UCI 1.2 men elite pro race Gran Premio New York City will be held on May 19, 2024 on the same course and same day as the 12th annual mass participation race Michelob ULTRA GFNY World Championship NYC. The...

Cycling

Events

Press Releases

March 20, 2024

Mountain Outpost Named Live Broadcast Partner for 2024 Western States Endurance Run.

Auburn, CALIFORNIA - March 20, 2024 /ENDURANCE SPORTSWIRE/ - The Western States Endurance Run (WSER) and Mountain Outpost, a North American leader in live broadcast production in trail and ultra running, are excited to announce a partnership to deliver the 2024 Western States Endurance Run livestream. Mountain Outpost will serve...

Business

Events

Press Releases

Triathlon

March 19, 2024

2024 XTERRA World Cup Premiers Live: Titans of Off-Road Triathlon Clash in Taiwan

Key Points: Taiwan's challenging landscape is the key opener for the 2024 XTERRA World Cup, where every race impacts overall points. Highlights include the Forissier brothers' rivalry and the showdown between Solenne Billouin and Alizée Paties. All the action will be livestreamed on Saturday, March 23rd at 5:50 pm EST....

Cycling

Events

Press Releases

Running

Triathlon

March 19, 2024

2024 XTERRA Asia-Pacific Championship: Triathletes & Trailblazers Ready for Battle

Key Points: XTERRA Taiwan to determine Asia-Pacific triathlon and trail running titles with limited slots for global championships in Trentino, Italy and Maine, USA. Sustainable trophies and medals from local wood sculptor emphasize XTERRA's eco-focus. Live commentary by XTERRA legends to offer in-depth analysis and historical insights for fans and...

Cycling

Events

Press Releases

Running

Triathlon

March 19, 2024

Men’s Singapore T100 Line Up Set To Continue Miami Rivalries

London, UK/ENDURANCE SPORTSWIRE/ – The Professional Triathletes Organisation (PTO) and World Triathlon have confirmed the line up for the men’s Singapore T100 triathlon on 14 April, 2024, the second stop on the new eight-leg T100 Triathlon World Tour. It features 15 of the world’s top 20 PTO Ranked athletes and...

Events

Press Releases

Triathlon