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

May 22, 2023

XTERRA Oak Mountain World Cup Weekend Wrap

/ENDURANCE SPORTSWIRE/ - More than 1,000 athletes from a dozen countries flocked to Oak Mountain State Park in Shelby County, Alabama over the weekend for the XTERRA World Cup debut in the U.S. The endurance sports festival kicked off on Thursday, May 18, with the Ales & Trails Bike Fest...

Events

Press Releases

Triathlon

May 21, 2023

Hug and Wilms take Wins at Challenge St Pölten

/ENDURANCE SPORTSWIRE/ - Lotte Wilms (NED) and Tom Hug (GER) are the winners of the Challenge St. Pölten 2023. Hug beat the competition on the run course, while Wilms celebrated a start-finish victory. 1,100 age group athletes from 33 nations completed the middle distance in St. Pölten in good weather...

Events

Press Releases

Triathlon

May 21, 2023

Margirier and Lee crowned Champions of The Championship 2023

/ENDURANCE SPORTSWIRE/ - Spectacular racing and new course records marked the sixth edition of The Championship with faultless racing from Mathis Margirier (FRA) and India Lee (GBR) earning them ultimate Challenge Family titles in 3:31:29 and 3:58:29 respectively, both breaking the course records previously held by Florian Angert (2021) and...

Events

Press Releases

Triathlon

May 19, 2023

2023 Garmin UNBOUND Gravel presented by Craft Sportswear to Host Largest Field in Event’s History

EMPORIA, Kan., (May 19, 2023)/ENDURANCE SPORTSWIRE/ – With approximately 4,000 riders, Life Time’s (NYSE: LTH) Garmin UNBOUND Gravel presented by Craft Sportswear will host its largest field ever, continuing its reign as the premier gravel cycling event for racers of all abilities. Among the thousands of riders toeing the start line during...

Cycling

Events

Press Releases

May 19, 2023

Qatar Airways IRONMAN Barcelona Latest Event to Sell Out General Registration; Limited Entries Remain for other IRONMAN and IRONMAN 70.3 Races in Europe

LONDON, UK. (May 18, 2023) /ENDURANCE SPORTSWIRE/ – IRONMAN announced today that general registration for Qatar Airways IRONMAN® Barcelona triathlon has now sold out, whilst several other IRONMAN and IRONMAN® 70.3® triathlons across Europe are also close to selling out. Qatar Airways IRONMAN Barcelona follows IRONMAN Karnten-Klagenfurt, Austria, IRONMAN European Championship...

Events

Press Releases

Triathlon

May 19, 2023

RunSignup Announces RaceJoy Now with Native Maps and Participant Pause

May 19, 2023 -Moorestown, NJ/ENDURANCE SPORTSWIRE/ - RunSignup, the leading registration and technology provider for endurance events in the United States, announces two significant advancements for its RaceJoy race day mobile app. As a RunSignup product designed to elevate the race day experience, RaceJoy now supports Google native maps and...

Business

Cycling

Events

Press Releases

Products

Running

Triathlon

May 19, 2023

The 2023 GFNY Hall of Fame Inductees

New York City, May 19, 2023/ENDURANCE SPORTSWIRE/ – On May 21, 2023, GFNY is holding the 11th edition of the GFNY World Championship NYC. On this occasion, the GFNY Hall of Fame will honor five new inductees to recognize their contribution to GFNY. In alphabetical order: Chris Geiser started at GFNY...

Cycling

Events

Press Releases

May 18, 2023

Davis Phinney Foundation Proudly Announces the 2023 Tour de Victory Cycling Challenge

Boulder, Colo. /ENDURANCE SPORTSWIRE/ - The Tour De Victory Cycling Challenge, a unique Colorado charity ride that raises funds and awareness for the Davis Phinney Foundation, is now open for registration and their list of 2023 sponsors and partners has been released. We are thrilled to announce that this year’s ride opening...

Business

Cycling

Events

Press Releases

May 18, 2023

XTERRA Portugal this Saturday in Golega

/ENDURANCE SPORTSWIRE/ – XTERRA Portugal, the sixth of 21 stops on the 2023 XTERRA EMEA Tour, takes place Saturday, May 20, in the beautiful countryside surrounding Golega. Horses rule the cobble-lined narrow streets in this historic village, which is known as the Portuguese capital of horses, so athletes can expect plenty...

Events

Press Releases

Triathlon