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

June 15, 2022

XTERRA Short Track Lures Off-Road Elite to France

June 15, 2022/ENDURANCE SPORTSWIRE/ –  The XTERRA off-road triathlon racing season heads into primetime July 2 in Xonrupt, France with the first of four events in the 2022 XTERRA Short Track Series. XTERRA Short Track is an invite-only event exclusive to the top 25 eligible men and women. While qualification procedures...

Events

Press Releases

Triathlon

June 15, 2022

Lake Sonoma Race Series Expands to Multiple Weekends with New Distances in 2022 and Looks for Even More in 2023

/ENDURANCE SPORTSWIRE/ – 2022 was a huge year for the iconic Lake Sonoma Race Series (LSRS), which has grown from its roots as a small-town charity race founded by John Medinger fifteen years ago into a four-race series with distances from the marathon up to 100K.  The relentlessly hilly, winding courses...

Events

Press Releases

Running

June 15, 2022

Professional Triathlete, Timothy O’Donnell, Qualifies for IRONMAN World Championships 15 Months After Harrowing On-Course Heart Attack

CAMBRIDGE, Mass.—June 15, 2022 /ENDURANCE SPORTSWIRE/ - Professional triathlete, Timothy O’Donnell, yesterday qualified for the IRONMAN World Championships in Kailua-Kona, Hawaii, with a time of 8:10:07 and a third-place finish at IRONMAN Des Moines. This marks the 11th time O’Donnell has qualified for the World Championships, but is remarkable in...

Events

Press Releases

Triathlon

June 15, 2022

Expedition Canada Takes World Series Adventure Racing Back to its Roots

/ENDURANCE SPORTSWIRE/ – Expedition Canada attracted international teams from 7 different nations to the town of Kelowna in British Columbia, Canada, for the 5th event in the 2022 Adventure Racing World Series. After staging a Demonstration Race last year, the event stepped up to full AR World Series membership this year,...

Events

Press Releases

June 14, 2022

GFNY Super Sunday results

New York City, June 14, 2022/ENDURANCE SPORTSWIRE/ – For the inaugural edition of GFNY Lourdes Tourmalet (France) racers tackled 157km with 4064m of climbing in the legendary French Pyrenees. Col d’Aspin was the first real obstacle of the day - and it didn’t disappoint. The peloton split into groups with the...

Cycling

Events

Press Releases