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

May 9, 2023

Puerto Princesa to Host The IRONMAN 70.3 Asia Triclub & Relay Championship this November

PUERTO PRINCESA, Philippines / TAMPA, Fla. (May 9, 2023)/ENDURANCE SPORTSWIRE/ – IRONMAN today announced that the IRONMAN® 70.3® Puerto Princesa triathlon taking place on November 12, 2023, will be designated as the 2023 Asia TriClub and Relay Championship for 2023. Puerto Princesa joins the 2023 Global IRONMAN TriClub Championship Series as...

Events

Press Releases

Triathlon

May 9, 2023

UltraSignup Announces Inaugural Event Series: the Dirt Circus

May, 2023 – Nashville, TN/ENDURANCE SPORTSWIRE/ – UltraSignup, the world's leading online registration platform for trail and ultra-running events, is excited to announce its first event series, The Dirt Circus. This exciting new event series is designed to bring the trail running community together in six different cities across the United...

Events

Press Releases

Running

May 9, 2023

Sports And Hollywood Stars Join Forces to Crush Cancer at The 11th Annual Tour De Pier

LOS ANGELES, Calif., May 9, 2023 – The 11th Annual Tour de Pier, a unique outdoor stationary cycling fundraiser is pleased to announce its star-studded lineup. The award-winning fitness fundraiser for Outstanding Special Event welcomes sports and Hollywood stars in helping create awareness about advancing cancer research. Celebrities scheduled to...

Business

Cycling

Events

Giving

Press Releases

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