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

August 27, 2023

Viain and Nieuwoudt Conquer Challenge Davos

/ENDURANCE SPORTSWIRE/ - Challenge Davos returned to the Swiss Alps today with convincing wins from Simon Viain (FRA) and Magda Nieuwoudt (RSA) in close to perfect conditions. Athletes took on the testing course that features a 1.9km swim in Lake Davos followed by the bike over the famous Flüela Pass,...

Events

Press Releases

Triathlon

August 26, 2023

Turkish Airlines announced as Official Airline Partner of RBC GranFondo Whistler

[Vancouver, BC Canada]/ENDURANCE SPORTSWIRE/ - Turkish Airlines, national flag carrier of Türkiye and 8 times winner of the Skytrax Best European Airline award, including in 2023, today announced a new partnership with RBC GranFondo Whistler, the largest Gran Fondo cycling event in North America, becoming Official Airline Partner. This partnership...

Business

Cycling

Events

Press Releases

Sponsorship

August 26, 2023

Back-To-Back: United States Taylor Knibb Defends Her Title at the 2023 Vinfast IRONMAN 70.3 World Championship Triathlon in Lahti, Finland

LAHTI, Finland (Aug. 26, 2023)/ENDURANCE SPORTSWIRE/ - American Olympian Taylor Knibb captured her second VinFast IRONMAN® 70.3® World Championship title in Lahti, Finland, on Saturday. After exiting the ROKA swim course in the top-3, Knibb quickly gained the lead on the FULGAZ bike course and never looked back. Putting in...

Events

Press Releases

Triathlon

August 24, 2023

Alchemy Bikes’ New Lycos Gravel Bike Now in Stock, Ready to Ship

Golden, Colorado (August 24, 2023) /ENDURANCE SPORTSWIRE/ - Following its recent dramatic reduction in the entry price for the Lycos family of full-carbon gravel bikes, Alchemy Bikes now has full size runs in all standard builds and colorways in house and ready to build to order and ship within two...

Business

Cycling

Press Releases

Products

August 24, 2023

XTERRA World Cup Rolls Into the Rockies

/ENDURANCE SPORTSWIRE/ – The sixth of seven stops on the inaugural XTERRA World Cup takes place this Saturday, August 26, high up in the Rockies at Beaver Creek Resort in Avon, Colorado. As the last full-distance race on the World Cup schedule prior to the XTERRA World Championship in Italy...

Events

Press Releases

Triathlon

August 24, 2023

Running USA Releases Highly Anticipated Annual Report On Running/Walking Trends in North America

Aug. 24, 2023/ENDURANCE SPORTSWIRE/ – Running USA has released the results of its highly-anticipated, annual Global Runner Survey. The 2023 Race Trends: Global Runner Survey is the most in-depth analysis into the mindset and behaviors of the running and walking community. Over 10,000 runners and walkers responded to the 2023 survey, making...

Press Releases

Studies

August 24, 2023

The Bayport Foundation Crawlin’ Crab Half Marathon Weekend Announces New 5K Course and Post Race Celebration Entertainment

August 24, 2023 – HAMPTON, VIRGINIA /ENDURANCE SPORTSWIRE/ – With over 2,500 runners expected to descend into Hampton the first weekend of October, the BayPort Foundation Crawlin’ Crab Half Marathon & 5K presented by Bon Secours is primed to be a spectacular experience. New for 2023 is a brand new and...

Events

Press Releases

Running

August 24, 2023

Ultra X Launch in the US

/ENDURANCE SPORTSWIRE/ – Global ultra-marathon events series, Ultra X launch their first race in the USA, a 5 day, 220km race around Red Rock Conservation Area and the Spring Mountain Recreation Area, adding to their collection of life-changing experiences. Ultra X Nevada is a multi-stage ultra-marathon taking place over five...

Events

Press Releases

Running