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

April 24, 2023

USATF U20 Mountain Running Team Announced

/ENDURANCE SPORTSWIRE/ – Eight athletes have been named to the 2023 USATF U20 Mountain Running Team slated to compete in the 2nd World Mountain and Trail Running Championships on Sunday, June 10, in Stubai – Innsbruck, Austria. The race will start in the center of town at Landestheater Vorplatz. The one-loop...

Events

Press Releases

Running

April 23, 2023

USA Triathlon Announces Omaha as Host of 2024 and 2025 Multisport National Championships

COLORADO SPRINGS, Colo. /ENDURANCE SPORTSWIRE/ - USA Triathlon, in partnership with Omaha Sports Commission and the City of Omaha, Nebraska, today announced that Omaha will host the 2024 and 2025 USA Triathlon Multisport National Championships Festival at Lake Cunningham June 5-9, 2024. The event, which will span over the course...

Events

Press Releases

Triathlon

April 22, 2023

Noble and Watkinson Take Wins at Challenge Taiwan

/ENDURANCE SPORTSWIRE/ - Over 8,000 athletes lined up this weekend for Asia’s largest long distance at Challenge Taiwan in Taitung and the return of pro racing to the event. Caleb Noble and Amelia Watkinson took out top honours in 3:45:17 and 4:03:40 respectively, both leading from the gun. In the...

Events

Press Releases

Triathlon

April 22, 2023

Exciting Racing Delivers Wins to Laidlow and Haug at Anfi Challenge Mogán-Gran Canaria

/ENDURANCE SPORTSWIRE/ - A stellar field, which included four of the top 12 PTO-ranked males, took on the tough and honest course at Anfi Challenge Mogán-Gran Canaria today with Sam Laidlow and Anne Haug proving they are a force to be reckoned with over this distance. There were no surprises...

Events

Press Releases

Triathlon

April 22, 2023

Rudy Von Berg (USA) And Kat Matthews (GBR) Claim Thrilling Victories at 2023 Memorial Herman IRONMAN the Americas Championship Texas Triathlon, Part of The Vinfast IRONMAN North America Series

THE WOODLANDS, Texas (April 22, 2023) /ENDURANCE SPORTSWIRE/ - The Woodlands, Texas welcomed the return of Memorial Herman IRONMAN The Americas Championship Texas triathlon, part of the VinFast IRONMAN North America Series to the Lone Star State on Saturday, April 22. In a thrilling sprint finish, Rudy von Berg (USA)...

Events

Press Releases

Triathlon

April 22, 2023

Sofia Gomez Villafane and Keegan Swenson win Life Time Grand Prix Season Opener at Sea Otter Classic Fuego XL Mountain Bike Race

Laguna Seca Raceway, Calif., (April 22, 2023) /ENDURANCE SPORTSWIRE/ - Sofia Gomez Villafane and Keegan Swenson rode to first place finishes at the Sea Otter Classic Fuego XL cross country mountain bike race, the opening round of the Life Time Grand Prix presented by Mazda. Swenson is the reigning series...

Cycling

Events

Press Releases

April 22, 2023

Approximately 24,000 Registered Runners Take On The 2023 St. Jude Rock ‘n’ Roll Running Series Nashville for A Running Tour of Music City

NASHVILLE, Tenn. (April 22, 2023)/ENDURANCE SPORTSWIRE/ – As the Rock ‘n’ Roll Running Series celebrates its 25 Years of Running, approximately 24,000 registered runners took part in the 2023 St. Jude Rock ‘n’ Roll Running Series Nashville providing participants a running tour of Music City. Saturday’s St. Jude Rock ‘n’ Roll...

Events

Press Releases

Running

April 21, 2023

For The First Time In History, L’Equipe Group to Broadcast 12 IRONMAN Races, Including Special Coverage of 2023 VinFast IRONMAN World Championship in Nice, France

NICE, France (21 April 2023)  /ENDURANCE SPORTSWIRE/ – IRONMAN and L’Equipe Group have announced a new broadcast partnership, which will see L’Equipe provide live coverage in France for 12 of the most prestigious IRONMAN races in 2023, including both the men’s and women’s editions of the VinFast IRONMAN® World Championship triathlon...

Business

Events

Press Releases

Triathlon

April 21, 2023

Santa Barbara Wine Country Half Marathon Returns in May

Solvang, California – April 21, 2023  /ENDURANCE SPORTSWIRE/ – The Santa Barbara Wine Country Half Marathon presented by Chumash Casino Resort is set to return on Saturday, May 13, 2023. The Spring running Tradition, annually held the Saturday of Mother’s Day Weekend, will bring an unforgettable experience for both runners and...

Events

Press Releases

Running