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

June 24, 2024

Rouvier and Morvillo Win XTERRA Switzerland Amidst Challenging Conditions

VALLÉE DE LA BRÉVINE, SWITZERLAND /ENDURANCE SPORTSWIRE/ – XTERRA Switzerland marked the 11th stop of the 2024 XTERRA EMEA Tour on June 22, 2024. Valentin Rouvier (FRA) and Bianca Morvillo (ITA) were victorious in the valley beneath the Neuchâtel mountains. The two-day event attracted both local and international competitors offering...

Cycling

Events

Press Releases

Running

Triathlon

June 24, 2024

Smiles Shine Through Rain-Soaked 2024 Boston 10K presented by Brigham and Women’s Hospital

BOSTON /ENDURANCE SPORTSWIRE/ – More than 8,100 athletes took part in today’s 2024 Boston 10K presented by Brigham and Women’s Hospital persevering through intermittent downpours to reach the finish at Boston Common. Sabastian Sawe (Kenya) and Melknat Wudu (Ethiopia) each won their first B.A.A. event, breaking the tape in 27:42...

Events

Press Releases

Running

June 24, 2024

Don’t Be Sorry, Be Better wins 2024 Teton Ogre Adventure Race

/ENDURANCE SPORTSWIRE/ – With several fast teams battling for the win amongst the 180 racers on several dozen teams, dot-watchers at home using the live-tracking system were on the edge of their seats until the final minutes of the race. This year’s 24-hour course, in Swan Valley, Idaho, on Saturday,...

Events

Press Releases

June 23, 2024

Lionel Sanders and Paula Findlay Lead a Canadian Sweep at the 2024 IRONMAN 70.3 Mont-Tremblant Triathlon

MONT-TREMBLANT, Quebec, Canada (June 23, 2024) /ENDURANCE SPORTSWIRE/ - On a rainy day in Canada’s Laurentian Mountains, the European-style ski village of Mont-Tremblant played host to the IRONMAN 70.3 Mont-Tremblant triathlon and the ninth stop of the IRONMAN Pro Series™. The race saw a Canadian sweep of the top spot...

Events

Press Releases

Triathlon

June 23, 2024

Bitados and Derron Triumph at Challenge Kaiserwinkl-Walchsee

/ENDURANCE SPORTSWIRE/ - It was a maiden win for Panagiotis Bitados (GRE) today at Challenge Kaiserwinkl-Walchsee as he crossed the line in first place in 3:41:42 after a blistering 1:09:24 run. Julie Derron (SUI) took her second win of the year in 4:03:38 with the next race on her schedule,...

Events

Press Releases

Triathlon