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

July 23, 2024

Excitement Builds for Challenge Turku Race Weekend

/ENDURANCE SPORTSWIRE/ – The Challenge Turku race weekend is set to take place in the heart of historic Turku on 27/28 July. It will feature Junior, Sprint, Challenge4All, and Middle-Distance events. With its fast and course and exciting pro field, this event promises an exhilarating experience for both participants and...

Events

Press Releases

Triathlon

July 23, 2024

Enabled Tracking to Provide Live GPS Tracking for July 2024 Endurance Events

Front Royal, VA – July 2024 /ENDURANCE SPORTSWIRE/ - Enabled Tracking, the timing and tracking division of Adventure Enablers, is pleased to unveil its advanced live GPS tracking services designed for a variety of past and upcoming endurance events this month. Whether navigating rugged terrains or conquering multi-day challenges, Enabled...

Business

Events

Press Releases

July 23, 2024

Close Battle in Challenge Family Pro Athlete World Bonus

/ENDURANNCE SPORTSWIRE/ - It’s been a busy couple of weekends with Challenge Family’s World Bonus with the high-scoring DATEV Challenge Roth, plus the inaugural SAIL Challenge Cap Québec both shaking things up in the pro athlete standings. The men’s league has a clear leader with Jack Moody, while the women’s...

Events

Press Releases

Triathlon

July 22, 2024

The Countdown is on to Leadville Trail 100 MTB

Leadville, Colorado /ENDURANCE SPORTSWIRE/ – The Life Time Grand Prix presented by Mazda returns on Saturday, August 10th with the Life Time Leadville Trail 100 MTB presented by Kenetik. The renowned Colorado event – also known as the Race Across the Sky – is celebrating its 30th anniversary this year and...

Cycling

Events

Press Releases

July 22, 2024

Trevor Foley (USA) And Danielle Lewis (USA) Take Wins at the 25th Anniversary Edition of The Athletic Brewing IRONMAN Lake Placid Triathlon

LAKE PLACID, N. Y. /ENDURANCE SPORTSWIRE/ - The village of Lake Placid and New York’s stunning Adirondacks Mountains played host to the twelfth stop and fifth full-distance IRONMAN triathlon in the IRONMAN Pro Series™ today at the Athletic Brewing IRONMAN® Lake Placid triathlon, part of the VinFast IRONMAN North America...

Events

Press Releases

Triathlon

July 22, 2024

2024 XTERRA European Trail Run Championship Recap: A Spaniard Sweep

ARINSAL - LA MASSANA, ANDORRA /ENDURANCE SPORTSWIRE/ - On July 21, 2024, the XTERRA European Trail Run Championship was held in the Pyrenees, attracting trail runners from across Europe and beyond. In the 36K Trail Marathon, the winners were Martí Lázaro Cordero (ESP) and Roser Español Bada (ESP), while the...

Events

Press Releases

Running

July 22, 2024

31,000 Runners Register For 2024 San Francisco Marathon Weekend Events

San Francisco, CA. – [Jul 22, 2024] /ENDURANCE SPORTSWIRE/ - Jumping Fences, Inc., the organizers of the iconic San Francisco Marathon, officially announces its return July 27-28, 2024. Bringing together thousands of runners from across the globe to participate in one of the world's most scenic and challenging running events,...

Events

Press Releases

Running