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

September 11, 2023

XTERRA European Trail Run Championship: Haunschmidt, Merli Win Marathon Distance While Zizzamia, Borg Take Half Marathon Titles

/ENDURANCE SPORTSWIRE/ – In the heart of the Brenta Dolomites, a UNESCO World Heritage site, the XTERRA European Trail Run Championship unfolded against a backdrop of incredible views and intense competition. Starting from the serene Lake Molveno and traversing the central Brenta region, trail runners vied for a share of...

Events

Press Releases

Running

Triathlon

September 11, 2023

History Making Day In At The VinFast IRONMAN World Championship As The Event Takes Place Outside Of The United States For The First Time

- The 2023 VinFast IRONMAN World Championship hosted a men’s-only field in Nice - France’s Sam Laidlow becomes the first athlete from France to win the IRONMAN World Championship; Laidlow is the youngest athlete to win the pinnacle event NICE, France (Sep. 11, 2023)/ENDURANCE SPORTSWIRE/ – For the first time in...

Events

Press Releases

Triathlon

September 10, 2023

France’s Sam Laidlow Captures First IRONMAN World Championship Title on Home Soil At 2023 Vinfast IRONMAN World Championship in Nice, France

NICE, France (Sept. 10, 2023) /ENDURANCE SPORTSWIRE/ - History was made on Côte de Azur today, as the first-ever VinFast IRONMAN World Championship to take place in Europe unfolded in Nice, France. It was Sam Laidlow, racing for France, who enjoyed a dominant victory on home soil. Laidlow used a...

Events

Press Releases

Triathlon

September 10, 2023

Swenson and Stephens Win First-Ever Elite Gravel National Titles

GERING, Neb. /ENDURANCE SPORTSWIRE/ - The first-ever USA Cycling Gravel National Championships kicked off on Saturday morning in downtown Gering, Nebraska. In total, 41 separate categories competed for the opportunity to earn a gravel national title across four different courses: 131.4 miles, 88 miles, 52.6 miles, and 24.8 miles. The...

Cycling

Events

Press Releases

September 10, 2023

Spectacular European Championship at Challenge Almere-Amsterdam: Menno Koolhaas wins in new record, stunning victory for Els Visser

/ENDURANCE SPORTSWIRE/ - Two Dutchmen on the top step of the podium at Challenge Almere-Amsterdam: it hasn’t happened for more than ten years, but today of all days, during the European Championships, it happened. On an already historic day Menno Koolhaas broke the course record and finished in 7:36:36 to...

Events

Press Releases

Triathlon

September 9, 2023

Second India National AR Championship Starts at Goa

/ENDURANCE SPORTSWIRE/ – The second 2023 Adventure Racing Championship India (ARCI) takes place this weekend in Goa. The race is a National Championship event which is also the qualifier for the ARWS Asia Regional Championship and is hosted by NthAdventure, India’s only licensed ARWS organization. Adventure Racing is a fast-growing...

Events

Press Releases

September 8, 2023

6,000 Runners Ready to Race at 2023 Volvo Santa Monica Classic

SANTA MONICA, CA – September 08, 2023 /ENDURANCE SPORTSWIRE/ – The stage is set, registration is sold-out and an exhilarating day of running and breathtaking views are in store for more than 6,000 runners as the Volvo Santa Monica Classic presented by ASICS returns this Sunday, September 10. Featuring three distances...

Events

Press Releases

Running

September 7, 2023

B.A.A. Announces Expanded Para Athletics Divisions & Enhanced Prize Money Awards for 2024 Events

BOSTON /ENDURANCE SPORTSWIRE/ – The Boston Athletic Association (B.A.A.) today announced plans for an enhanced prize money structure across B.A.A. events in 2024, as well as the introduction of two new Para Athletics Divisions for athletes competing with coordination impairments (T35-T38) and intellectual impairments (T20) as well as more inclusive upper...

Events

Press Releases

Running