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

August 17, 2022

XTERRA Germany Elite Preview

August 17, 2022 /ENDURANCE SPORTSWIRE/ -  XTERRA returns to Zittau, Germany for the 20th time with an action-packed weekend of Short Track and full distance off-road triathlon racing this Friday and Saturday, August 19-20. As the name suggests, Friday’s XTERRA Short Track race is a fast, multi-lap, made-for-TV event combining...

Events

Press Releases

Triathlon

August 17, 2022

1300 racers at Inaugural GFNY Oaxaca

New York City, August 17, 2022 /ENDURANCE SPORTSWIRE/ – A head to head sprint decided the male race at the Inaugural Ford GFNY Oaxaca after 116.5km with an elevation gain of 1850m. 1300 riders from more than 25 countries tackled the race that included iconic Ixtepeji which reaches an altitude of...

Cycling

Events

Press Releases

August 16, 2022

The NCL Launches First-Of-Its-Kind Professional Cycling League with Venture and Celebrity Investors and a 2023 Race Series

MIAMI, FL /ENDURANCE SPORTSWIRE/ - Today, the NCL (National Cycling League, Inc.) announced the launch of a first-of-its-kind professional cycling league. With 60 million riders in the United States and over 2 billion worldwide, American professional cycling is positioned to become one of the most popular sports in the world...

Business

Cycling

Events

Press Releases

August 16, 2022

One Water Race Starts August 23rd

/ENDURANCE SPORTSWIRE/ - On August 23rd -25th, the first official One Water Race will take place. One Water Race is the world's toughest endurance race. The race has gained a lot of attention and the world's best endurance athletes visit to Stockholm to challenge all physical and mental limits and...

Events

Press Releases

Products

Running

Sponsorship

Studies

Triathlon

August 15, 2022

XTERRA European Championship Rewind from Prachatice

/ENDURANCE SPORTSWIRE/ - Arthur Serrieres from France and Sandra Mairhofer from Italy captured the XTERRA European Championship in conjunction with the 18th annual XTERRA Czech off-road triathlon with winning times of 2:30:16 and 2:57:39, respectively, on Saturday, August 13, 2022, in Prachatice, then put their speed and skill on full...

Business

Events

Press Releases

Products

Triathlon

August 15, 2022

1,400 Participants Took on ODU’s Campus in the 9th Running of The Big Blue 5k

AUGUST 13, 2022 – NORFOLK, VIRGINIA /ENDURANCE SPORTSWIRE/ - Close to 1,400 participants strutted their Old Dominion University pride at the Big Blue 5K presented by Bon Secours. Participants weaved their way through ODU’s campus and were cheered on by the ODU Football, Lacrosse and Volleyball teams. One of the...

Events

Press Releases

Running

August 15, 2022

Big Sur Marathon Foundation Names New Executive/Race Director

August 15, 2022, CARMEL, CA /ENDURANCE SPORTSWIRE/ - Josh Priester has been named the new Executive Director/Race Director of the 36-year-old Big Sur Marathon Foundation (BSMF). Priester, who offers a wealth of experience in sports management, athlete coaching, and business development, is tasked with furthering the nonprofit organization’s mission to create...

Events

Press Releases

Running