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

May 9, 2023

The Championship 2023 Confirms Final World-Class Field

/ENDURANCE SPORTSWIRE/ – With less than two weeks to go until Challenge Family’s flagship event, The Championship, a world-class 70-strong professional field has been confirmed, including the sport’s newest World Triathlon Long Distance World Champions, Clément Mignon and Marjolaine Pierré. Taking place at the x-bionic® sphere Olympic training venue in Šamorín,...

Events

Press Releases

Triathlon

May 8, 2023

San Diego’s Steven Martinez wins 2023 SDCCU Marathon with new course record

ORANGE COUNTY, California - May, 2023/ENDURANCE SPORTSWIRE/ – Steven Martinez’s goals for Sunday’s SDCCU OC Marathon were modest and unselfish. He planned to run about 18 miles, pacing a friend to what they hoped would be an Olympic Trials qualifying time. But after 10 miles it was apparent Martinez’s former Chico...

Events

Press Releases

Running

May 8, 2023

Charboneau and Corcoran Victorious at USATF Marathon Trail Running Championships

/ENDURANCE SPORTSWIRE/ – At the USATF Marathon Trail Running Championships hosted by Breakneck Point in Beacon, NY, on Saturday, May 6, Brittany Charboneau, 34, Denver, CO, and Garrett Corcoran, 27, Salt Lake City, UT, battled a stellar field to win top honors in the race. Not only did the pair win...

Events

Press Releases

Running

May 8, 2023

Colorado State, US Air Force Academy, and Colorado Mesa Take Home Team Omnium Titles at Collegiate Road Nationals

Albuquerque, N.M. /ENDURANCE SPORTSWIRE/ – The 2023 USA Cycling Collegiate Road National Championships saw student-athletes representing 36 states and 57 schools descend upon Albuquerque May 5-7, 2023. The group contested for titles in 14 events across three venues around the city in those three days. Team Time Trial On Friday, teams...

Cycling

Events

Press Releases

May 8, 2023

Registration for the 2024 Ascension Seton Austin Marathon Officially Opens May 9

AUSTIN, Texas, May 8, 2023/ENDURANCE SPORTSWIRE/ – Registration for the 2024 Ascension Seton Austin Marathon, Half Marathon & 5k® officially opens Tuesday, May 9th. To mark the opening, there will be a week-long celebration that includes giveaways, promotions, group runs, and social gatherings. In addition, for each registration during Launch Week,...

Events

Press Releases

Running

May 6, 2023

Sam Long (USA) And Jeanni Metzler (ZAF) Top Competition at Intermountain Health IRONMAN 70.3 North American Championship St. George Triathlon

ST. GEORGE, UTAH. (May 6, 2023) – Southwestern Utah and the Greater Zion region welcomed the return of Intermountain Health IRONMAN® 70.3® North American Championship St. George triathlon on Saturday, May 6. With some of triathlon’s best talent on hand, the event saw Sam Long (USA) capture the overall victory...

Events

Press Releases

Triathlon

May 5, 2023

General Registration For 2023 Kaiser Permanente IRONMAN California Triathlon, Part of The Vinfast IRONMAN North America Series, Officially Sold Out

SACRAMENTO, Calif. (May 5, 2023) /ENDURANCE SPORTSWIRE/ - IRONMAN announced today that general registration for the 2023 Kaiser Permanente IRONMAN® California triathlon, part of the VinFast IRONMAN North America Series, has officially sold out. Limited entries remain available through The IRONMAN Foundation and Enhanced Athlete Event Experiences powered by NIRVANA....

Events

Press Releases

Triathlon

May 5, 2023

Parkinson’s cyclists prepare to take on a 1000-mile Cycle Challenge to raise awareness for the debilitating disease

5th May 2023, UK/ENDURANCE SPORTSWIRE/ – Leading indoor cycling performance brand, Wattbike are excited to be supporting Sport Parkinson’s in a 1000-mile Cycle Challenge. On Saturday 6th May 2023 a team of four cyclists, all of whom have Parkinson's, will take on the grueling challenge of cycling 1000 virtual miles from...

Cycling

Events

Giving

Press Releases

May 5, 2023

2023 PTO Tour Goes Global – Each Round To Be Broadcast Live In 195 Territories Worldwide

Ibiza/ENDURANCE SPORTSWIRE/ – 2023 PTO Tour events will be broadcast live in a record 195 territories, reaching 425 million Households and be translated into 22 languages when the curtain rises on the first-ever PTO European Open in Ibiza tomorrow (6 May). Led by the PTO’s broadcast partnerships with Warner Bros. Discovery,...

Events

Press Releases

Triathlon