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

September 12, 2022

IRONMAN Returns to Belgium with the Inaugural IRONMAN 70.3 Knokke-Heist Triathlon Event

KNOKKE-HEIST, Belgium / LONDON, UK / TAMPA, Fla. (September 12, 2022) /ENDURANCE SPORTSWIRE/ –IRONMAN has announced the return to Belgium in 2023 with IRONMAN® 70.3® Knokke-Heist, Belgium set to take place on September 17, 2023. The inaugural IRONMAN 70.3 Knokke-Heist, Belgium will mark the return of the brand to Belgium for...

Events

Press Releases

Triathlon

September 12, 2022

Paraguay Prepares to Host the 18th Adventure Racing World Championship

/ENDURANCE SPORTSWIRE/ - The 18th Adventure Racing World Championship begins in Paraguay on Saturday, September 17th, and teams from around the world will be arriving in the capital city of Asunción in the coming days. The race will be hosted by Expedición Guaraní, which has been a member of the...

Events

Press Releases

September 11, 2022

Lindars and Wolf Take European Titles at Challenge Almere-Amsterdam

/ENDURANCE SPORTSWIRE/ - A so-called sufferfest; that’s what Challenge Almere-Amsterdam turned into. From flat tires, to mechanical issues and athletes blowing themselves up when pushing against the wind during the bike. Kieran Lindars and Katharina Wolff were not having any of it, though. Both athletes (Lindars from Great-Britain and Wolff...

Events

Press Releases

Triathlon

September 11, 2022

Over 2,400 Athletes Converge in Madison, Wisconsin for a Festival Weekend of Racing

MADISON, Wisc. (Sept.11, 2022) – The Wisconsin State Capitol and scenic Dane County played host to over 2,400 athletes from around the world for the 2022 IRONMAN Wisconsin, a part of the VinFast U.S. Series, and IRONMAN 70.3 Wisconsin triathlons as part of a festival weekend of racing on Saturday,...

Events

Press Releases

Triathlon

September 9, 2022

Electrolit Announces Official Partnership with The McCourt Foundation

September 9, 2022, CERRITOS, Calif. --/ENDURANCE SPORTSWIRE/ - Electrolit – the preferred, premium hydration beverage made from pharmaceutical quality grade ingredients – is delighted to announce a multiyear partnership with The McCourt Foundation, becoming the official hydration partner for the Los Angeles Marathon presented by ASICS and other major running events...

Events

Press Releases

Running

Sponsorship

September 9, 2022

Run Catalina Announces Lightfoot Coaching Training Programs for Run Catalina Athletes as the Official Coach of Run Catalina events

/ENDURANCE SPORTSWIRE/ - Run Catalina announced today the addition of Lightfoot Coaching training programs for its trail athletes. “Proper trail training is crucial for runners competing on any of our Run Catalina courses, which are filled with challenging peaks, elevation changes, and rewarding views of Catalina Island. We are offering...

Business

Events

Press Releases

Running

Sponsorship

September 9, 2022

Inaugural Monarch Triathlon champions women fighting cancer and their families

KINGMAN, Ariz. /ENDURANCE SPORTSWIRE/ - SheStrong Inc. has opened registration for the Monarch Triathlon SuperHalf™, a brand new women’s multisport event that will take to the waterways and roadways of Kingman and Bullhead City, Ariz. on Oct. 22. The nonprofit’s inaugural race will be the first-ever USA Triathlon Sanctioned Event...

Events

Giving

Press Releases

Triathlon

September 9, 2022

rabbit Co-Founders Keep Dreaming at Cascade Express Marathon

/ENDURANCE SPORTSWIRE/ -Monica DeVreese and Jill Deering, co-founders of rabbit, the free-spirited, California running apparel brand, know what it means to dream. Their original dream? To create a running apparel brand that married style, function and fit. When they first concocted the idea years ago, they utilized their 30-plus years...

Business

Events

Press Releases

Running

September 9, 2022

Defiant Hauser Has a Point to Prove as Super League Triathlon Returns to Munich

/ENDURANCE SPORTSWIRE/ – Defiant Matt Hauser insists his recovery from an incorrect penalty proves he is a genuine title contender as Super League Triathlon returns to Munich, Germany, this weekend. The Australian was second out of the water of the Stage 1 swim in the Championship Series opener in London, but...

Events

Press Releases

Triathlon