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

October 24, 2023

2022 National Pro Road Champion Joins Virginia’s Blue Ridge TWENTY24

ROANOKE, Virginia — October 24, 2023 /ENDURANCE SPORTSWIRE/ - Virginia’s Blue Ridge TWENTY24 pro cycling has signed 2022 National Road Champion Emma Langley for the 2024 and 2025 seasons. Langley will bring her climbing prowess along with her world tour experience that she gained from three years with EF Education-Tibco-SVB....

Cycling

Events

Press Releases

Sponsorship

October 24, 2023

Ascension Seton Austin Marathon Offers Official Sponsorship Opportunities

AUSTIN, Texas, October 24, 2023 /ENDURANCE SPORTSWIRE/ – The Ascension Seton Austin Marathon, Half Marathon, and 5k is actively pursuing official sponsorships from companies interested in aligning their brand with the sport’s running social event of the year. The 2023 Austin Marathon boasted an impressive collective of 80,000 individuals, including participants,...

Events

Press Releases

Running

Sponsorship

October 23, 2023

Echelon Racing Promotions and USA Cycling Announce Esports League and National Championships on Zwift

COLORADO SPRINGS, Colo. /ENDURANCE SPORTSWIRE/ – USA Cycling is proud to announce that it has partnered with Echelon Racing Promotions to host a six-race series that will serve as a qualifier for the USA Cycling Esports Elite National Championships. All races will be held on Zwift, the world's largest virtual cycling...

Cycling

Events

Press Releases

Sponsorship

October 23, 2023

XTERRA Tahiti: Ruzafa and Billouin Conquer in Grand Finale

/ENDURANCE SPORTSWIRE/ – The 2023 XTERRA World Tour concluded in the breathtaking surroundings of Moorea, Tahiti. Champions Ruben Ruzafa (ESP) and Solenne Billouin (FRA) triumphed in the XTERRA Tahiti Full Distance Triathlon. Amidst the captivating beauty of Moorea's lagoon waters and dense jungle trails, over 300 athletes from around the world...

Events

Press Releases

Triathlon

October 23, 2023

Dan Plews (Auckland, New Zealand) And Kristen Yax (Bend, Oregon, United States) Top Finishers at the 2023 Kaiser Permanente IRONMAN California Triathlon, Part of The Vinfast IRONMAN North America Series

SACRAMENTO, Calif. /ENDURANCE SPORTSWIRE/ - California’s Capital City and its surrounding areas provided a stunning backdrop for the 2023 Kaiser Permanente IRONMAN® California triathlon, part of the VinFast IRONMAN North America Series, on Sunday, October 22, 2023. Dan Plews from Auckland, New Zealand (M40-44 Age Group) took the overall victory...

Events

Press Releases

Triathlon

October 23, 2023

SUAREZ Gran Fondo National Series Opens 2024 Registration

(Gettysburg, PA – October 23, 2023) /ENDURANCE SPORTSWIRE/ - Founded in 2012 by event director Reuben Kline, the SUAREZ Gran Fondo National Series is the largest and most competitive series of gran fondo cycling events in the United States. New for 2024, custom event-specific jerseys from Suarez Cycling Apparel will...

Business

Cycling

Events

Press Releases

October 23, 2023

The USA Women’s Half Marathon Sprints Into Dallas This Month

DALLAS/ENDURANCE SPORTSWIRE/ – On your mark. Get set. Go! USA Endurance Events, a road race company offering luxury racing experiences in select cities throughout the U.S., has chosen Dallas for its upcoming USA Women’s Half Marathon on Saturday, Oct. 28, at White Rock Lake. Since 2013, USA Endurance Events has hosted...

Events

Giving

Press Releases

Running

October 22, 2023

Sofia Gomez Villafane and Keegan Swenson Win 2023 Life Time Grand Prix presented by Mazda; Kasia Niewiadoma and Torbjørn Andre Røed Win Big Sugar Gravel

Bentonville, Ark., (Saturday, October 21, 2023) /ENDURANCE SPORTSWIRE/ - Life Time Big Sugar Gravel presented by Mazda took place in Northwest Arkansas and Southwest Missouri today with a field of more than 1,900 riders. Participants represented 36 states and 11 countries and ranged in age from 14 to 79. The...

Awards

Cycling

Events

Press Releases

October 21, 2023

Kate Waugh and Léo Bergere crowned 2023 Super League Triathlon Championship Series winners

NEOM, Saudi Arabia/ENDURANCE SPORTSWIRE/ - Great Britain’s Kate Waugh and Léo Bergere of France won the 2023 Super League Triathlon Championship Series titles in NEOM, Saudi Arabia. The women’s race saw Waugh, 24, finishing ahead of Luxembourg’s Jeanne Lehair and France’s Emma Lombardi on the day and in the Series...

Events

Press Releases

Triathlon

October 21, 2023

Margirier and Pohle Take Inaugural Titles at Challenge Vieux Boucau

/ENDURANCE SPORTSWIRE/ - The rain and the wind played its part at the inaugural Challenge Vieux Boucau, but the drama was at the finish line with Mathis Margirier (FRA) taking the home win in a thrilling sprint finish with Mika Noodt (DEU) while Caroline Pohle (DEU) came out on top...

Events

Press Releases

Triathlon