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

May 25, 2023

Star U.S. Elite Triathletes to Race At World Triathlon Championship Series Cagliari

COLORADO SPRINGS, Colo./ENDURANCE SPORTSWIRE/ – U.S. elite triathletes including No. 2 world ranked Taylor Spivey (Redondo Beach, Calif.) and Olympic medalists Katie Zaferes (Cary, N.C.) and Gwen Jorgensen (Boulder, Colo.) will compete this Saturday, May 27, in Cagliari, Italy, at the 2023 World Triathlon Championship Series Cagliari. Cagliari will see 10 U.S. elite triathletes compete at the third...

Events

Press Releases

Triathlon

May 25, 2023

XTERRA Italy – Lake Garda pits Serrières vs. Kulhavý

/ENDURANCE SPORTSWIRE/ – The sixth stop on the 2023 XTERRA EMEA Tour takes participants to the town of Toscolano-Maderno on the western shores of Lake Garda in Italy this Saturday, May 27, for one of the toughest off-road triathlon challenges on the global circuit. "You cannot start this race hoping...

Events

Press Releases

Triathlon

May 25, 2023

The Music Run Returns to Singapore In Partnership with PTO Asian Open

Singapore/ENDURANCE SPORTSWIRE/ – The Professional Triathletes Organisation (PTO) has announced a partnership with popular running brand The Music Run to create an accessible and fun-packed option for its PTO Asian Open weekend on 19-20 August in Singapore. After five years, The Music Run will make a much-anticipated return to the Lion City...

Events

Press Releases

Running

Triathlon

May 25, 2023

London Triathlon joins Challenge Family

Partnership with LimeLight and Challenge Family sees rebranded event named as Challenge London First time a Challenge Family event has ever been held in London Middle distance ‘blue riband’ event to be added London, UK /ENDURANCE SPORTSWIRE/ – The world’s biggest city centre triathlon, the London Triathlon, has become part of the...

Events

Press Releases

Triathlon

May 25, 2023

Gift registration for Airmen returns for 2023 Air Force Marathon

WRIGHT-PATTERSON AIR FORCE BASE, Ohio /ENDURANCE SPORTSWIRE/ - Air Force Marathon registrants can gift a paid entry fee to junior active-duty, Reserve and Guard enlisted service members for the event in September. Gift registrations are available for the 5K, 10K, half and full marathons. “We love the gift registration program...

Events

Giving

Press Releases

Running

May 25, 2023

2022’s best GFNY course this Sunday

New York City, May 25, 2023 /ENDURANCE SPORTSWIRE/ - This Sunday, GFNY Villard de Lans offers riders a challenging 163,4 km race course with an elevation gain of 3973m. Athletes will tackle a spectacular route in the mountainous Vercors region with the base at an altitude of 1050m. “The roads...

Cycling

Events

Press Releases

May 24, 2023

George Municipality and Mountain Ultra-Trail by UTMB® announce new partnership that sees the city and tourism board as Official Host Venue; a partnership that will showcase both the event and race venue globally.

- The event features a professional ultra trail line up with local stars Ryan Sandes and Rebecca Kohne who won her category last month at Istria 100 by UTMB® in Croatia. Images and race content can be found: HERE (GEORGE, South Africa) 24 May 2023 /ENDURANCE SPORTSWIRE/ – For the first time...

Events

Press Releases

Running

May 24, 2023

Run – and Raise Funds with the 2023 TCS Toronto Waterfront Marathon Charity Challenge

TORONTO, ON /ENDURANCE SPORTSWIRE/ – The annual TCS Toronto Waterfront Marathon is celebrating the 20th anniversary of its Charity Challenge. Today marks the official launch of the 2023 season, and participants across Toronto and around the globe can sign up to run for a cause or donate to over 150 Charity...

Events

Giving

Press Releases

Running

May 24, 2023

Expedition Canada Returns to Penticton to Explore Wild British Columbia

/ENDURANCE SPORTSWIRE/ – The third edition of Expedition Canada is the also the third Adventure Racing World Series Qualifier of the year, attracting teams from Canada, the USA, Japan, France and Poland. Twenty teams are now gathering in the town of Penticton to prepare for an epic 590km race which is...

Events

Press Releases