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

May 22, 2023

Ryan Sandes headlines the inaugural Mountain Ultra-Trail by UTMB® as he takes on a 100-Miler trail run in George, Western Cape

South Africa’s most famous trail runner, Ryan Sandes, to race in the event’s first ever 100-Miler distance. Mountain Ultra-Trail by UTMB® to welcome local and international runners to the Western Cape of South Africa this week on 26 - 28 May 2023; the event takes place in the Garden city...

Events

Press Releases

Running

May 22, 2023

Ongaki, Kelly win XTERRA Americas Trail Run Championship Marathon

/ENDURANCE SPORTSWIRE/ - Sameul Ongaki from Kenya and Megan Kelly from Atlanta, GA captured the inaugural XTERRA Americas Trail Run Championship 42K race on a beautiful day at Oak Mountain State Park in Shelby County, Alabama on Sunday, May 21, 2023, while Sebastien Carabin from Belgium and Taryn Garlington from...

Press Releases

Running

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

BibBoards Sparks a Controversy: Embracing Innovation and Sponsorships for Race Success

/ENDURANCE SPORTSWIRE/ – In a bold move that challenges tradition and sparks debate, BibBoards, the leading provider of innovative bib fasteners, is calling on runners and race organizers to break free from the shackles of safety pins and embrace a new era of sponsorship opportunities. With their cutting-edge design and branding...

Cycling

Press Releases

Products

Running

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 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