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

August 2, 2023

RTS Warriors USA And Proud In Super League Triathlon’s 2023 Championship Series

LONDON, UK/ENDURANCE SPORTSWIRE/ – RTS (Real Triathlon Squad) have promised to bring short-course racing back to the fore in the USA - and their actions are already speaking louder than words with the announcement of an RTS Warriors team that delivers stars of the present and the future. While other teams have...

Events

Press Releases

Triathlon

August 2, 2023

Cycling Time Trials reveal important update to National Championship Conditions

2nd August 2023 - UK/ENDURANCE SPORTSWIRE/ – Cycling Time Trials (CTT) is the governing body for time trials in the UK, and the team promotes a wide range of events across the UK, set over a variety of distances, locations and terrains. Events span across fast and flat “drag strips”, in which...

Cycling

Events

Press Releases

August 2, 2023

Sofia Gomez Villafane, Sami Inkinen, and Holly Guymon Take Overall Wins at the Stages Cycling Leadville Stage Race produced by Life Time

Leadville, Colo. /ENDURANCE SPORTSWIRE/ - The Stages Cycling Leadville Stage Race, owned and produced by Life Time (NYSE: LTH) as part of the Leadville Race Series, took place this past weekend from July 28-30. The event’s stage race format spreads out the Stages Cycling Leadville Trail 100 MTB course over three...

Cycling

Events

Press Releases

August 2, 2023

Race Results for the 24th Molokaˈi-2-Oˈahu Paddleboard World Championship

HONOLULU, HI (August 2, 2023) – The 24th Molokaʻi-2-O’ahu Paddleboard World Championships (M2O), presented by the Hawai’i Tourism Authority returned to racing today after a three-year hiatus due to the pandemic. Racers were greeted with favorable conditions with trade winds blowing at 20 knots and wind swell at six feet....

Events

Press Releases

August 2, 2023

UltraSignup Presents the Bentonville Dirt Circus 10K and 5K: With a $10,000 Prize Purse for the 10K Trail Race

August 2, 2023 – Nashville, TN/ENDURANCE SPORTSWIRE/ – UltraSignup, in collaboration with Rush Running Company and Visit Bentonville, is thrilled to announce the inaugural Bentonville Dirt Circus 10K and 5K races, set to take place on November 17-18, 2023, in the picturesque city of Bentonville, Arkansas. This groundbreaking event promises to be...

Events

Press Releases

Running

August 1, 2023

Sofia Gomez Villafane, Sami Inkinen, and Holly Guymon Take Overall Wins at the Stages Cycling Leadville Stage Race produced by Life Time

Leadville, Colo./ENDURANCE SPORTSWIRE/ - The Stages Cycling Leadville Stage Race, owned and produced by Life Time (NYSE: LTH) as part of the Leadville Race Series, took place this past weekend from July 28-30. The event’s stage race format spreads out the Stages Cycling Leadville Trail 100 MTB course over three...

Cycling

Events

Press Releases

August 1, 2023

Kristian Blummenfelt Leads Stacked Santara Tech Eagles in Super League Triathlon’s 2023 Championship Series

LONDON, UK/ENDURANCE SPORTSWIRE/ – Tim Don and Kristian Blummenfelt have united to form the Santara Tech Eagles for Super League Triathlon's 2023 Championship Series. Don, the legendary former athlete turned Team Manager, has brought on board Olympic champion Blummenfelt in a signing that also sees the company the Norwegian part-owns take over...

Events

Press Releases

Triathlon

August 1, 2023

RACE RESULT releases new and enhanced registration tools in the RACE RESULT 12 software

August 1, 2023 /ENDURANCE SPORTSWIRE/ - RACE RESULT is proud to present an advanced online registration tool that brings even more clarity and convenience to the process of creating registration forms. The new tool is integrated into the existing RACE RESULT 12 software, which combines essential features such as registration...

Business

Cycling

Events

Press Releases

Products

Running

Triathlon