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 (8742)
) 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

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 21, 2023

A Packed Weekend of IRONMAN and IRONMAN 70.3 Racing in Europe with Races In Kraichgau (Germany), Aix-En-Provence (France) and Lanzarote

KRAICHGAU, Germany / AIX-EN-PROVENCE, France (May 21, 2023) /ENDURANCE SPORTSWIRE/ - Europe played host to three of the seven global IRONMAN® and IRONMAN® 70.3® Triathlon events this weekend, with today’s races featuring IRONMAN 70.3 Kraichgau powered by KraichgauEnergie taking place in Germany and IRONMAN 70.3 Aix-En-Provence taking place in France....

Press Releases

Triathlon

May 19, 2023

Electrolit Hydration Beverage Unveils New Mango Flavor

CERRITOS, Calif., May. 19, 2023/ENDURANCE SPORTSWIRE/ – Electrolit – the preferred, premium hydration beverage made from pharmaceutical quality grade ingredients – announced today the launch of its newest flavor, Mango. This fruity new flavor joins the global brand’s now 15-strong line of hydration beverages. Launching May 19, Electrolit Mango will be exclusively...

Press Releases

Products

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