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 (8742)
) 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 4320, 10

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

October 20, 2023

XTERRA Tahiti: A Tropical Triathlon Showdown Caps the 2023 Season

Moorea, Tahiti /ENDURANCE SPORTSWIRE/ – The 2023 XTERRA World Tour is set to culminate in tropical lagoon waters and the surrounding jungle trails as the XTERRA Tahiti Triathlon brings a close to the season on October 21, 2023. Athletes from around the globe will converge on the island of Moorea, ready...

Events

Press Releases

Triathlon

October 20, 2023

B.A.A. Crowns 2024 Boston Middle School Cross Country Champions

Franklin Park, Boston, Mass. (20-Oct)/ENDURANCE SPORTSWIRE/ – Champions were crowned on a picture-perfect fall morning at the 2023 Boston Middle School Cross Country Championships on Thursday, October 19. Hosted by the Boston Athletic Association at Franklin Park, more than 350 middle school student-athletes from 14 City of Boston schools competed over a...

Events

Press Releases

Running

October 20, 2023

NERD Focus Returns as Official Energy Drink Partner of New Jersey Devils, Prudential Center

FREEHOLD, N.J (October 20, 2023)/ENDURANCE SPORTSWIRE/ – NERD Focus – the energy drink with powerful nootropics and performance-boosting nutrients – today announces its triumphant return as the official energy drink of the New Jersey Devils and Prudential Center for a second season. Building on the resounding success of their inaugural partnership, NERD...

Press Releases

Sponsorship

October 20, 2023

BMC official bike of GFNY USA 2024

New York City, October 20, 2023 /ENDURANCE SPORTSWIRE/ - BMC and GFNY are working together in 2024 to showcase their bikes to riders at races such as GFNY NYC, GFNY Miami, GFNY Sebring, GFNY Maryland Cambridge, and more. "I've been familiar with GFNY for quite some time and have participated...

Cycling

Events

Press Releases

October 20, 2023

2024 Ascension Seton Austin Marathon Opens Elite Athlete Program

AUSTIN, Texas, October 20, 2023 /ENDURANCE SPORTSWIRE/ – High Five Events, one of the largest privately owned event production companies in the United States, is accepting applications from elite runners for the 2024 Ascension Seton Austin Marathon. Returning for its seventh year, the Elite Athlete Program creates a competitive field of...

Events

Press Releases

Running

October 19, 2023

Registration Kickoff for the Visit Tuscaloosa Half Marathon & 5K Announced: Special Deals, Prizes, and Community Fun Await!

Tuscaloosa, AL /ENDURANCE SPORTSWIRE/ – The organizers of the Visit Tuscaloosa Half Marathon & 5K are excited to announce the opening of registration on Monday, October 23, 2023. Runners are encouraged to seize the opportunity to secure an exclusive limited time offer of $50 for the Half Marathon and $20 for...

Events

Press Releases

Running

October 19, 2023

UTMB World Series announce new partnership with Nirvana, to provide travel & accommodation solutions for runners

/ENDURANCE SPORTSWIRE/ – UTMB® World Series and Nirvana Europe Limited have announced a new partnership across North America, Europe and Oceania to provide runners with accommodation, travel and logistical solutions that will help make their race experience as smooth as possible. The company will support runners across 24 UTMB World...

Events

Press Releases

Running

Sponsorship

October 19, 2023

Embracing Elegance and Adventure with the new APEX 2 Dusty Pink from COROS

IRVINE, California / OCTOBER 19, 2023 /ENDURANCE SPORTSWIRE/ - COROS Wearables Inc., makers of GPS sports wearables and training software for multi-sport athletes, today announced the launch of APEX 2 Dusty Pink, a special edition colorway of its award-winning outdoor GPS watch, which pays tribute to the enchanting hues that...

Cycling

Press Releases

Products

Running

Triathlon

Wire Syndication