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

June 25, 2024

Over 40 Professional Athletes Line Up for Challenge Cagnes-sur-Mer

/ENDURANCE SPORTSWIRE/ – Challenge Family racing is back to France’s Côte d’Azur this weekend for the second edition of Challenge Cagnes-sur-Mer. This year's event features a strong professional field with 48 professional athletes competing. In the men's field, Jack Moody (AUS) has a great record. The Challenge Family Bonus ranking...

Events

Press Releases

Triathlon

June 25, 2024

The Countdown is on to Crusher in the Tushar

Beaver, Utah (Wednesday, June 25) /ENDURANCE SPORTSWIRE/ – The Life Time Grand Prix presented by Mazda returns for the third race of the series on Saturday, July 13th with the Life Time Crusher in the Tushar. This noted event in Beaver, Utah, is arguably the toughest 69.9-mile race on the planet...

Cycling

Events

Press Releases

June 24, 2024

IRONMAN Comes to Illinois for First Time with New IRONMAN 70.3 Triathlon to be Hosted in Rockford

- Inaugural IRONMAN 70.3 Rockford-Illinois triathlon is scheduled to take place on June 22, 2025 - General registration to open on July 1, 2024, at www.ironman.com/im703-rockford-illinois ROCKFORD, Ill. / TAMPA, Fla. (June 24, 2024) /ENDURANCE SPORTSWIRE/ – IRONMAN, the global leader in long-distance triathlon, announced today that it will host...

Events

Press Releases

Triathlon

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