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

July 31, 2023

Événements Sportifs Mont-Tremblant and IRONMAN Mutually Agree to Discontinue IRONMAN Mont-Tremblant Triathlon following 2023 Edition

MONT-TREMBLANT, QUÉBEC, CANADA (July 31, 2023) /ENDURANCE SPORTSWIRE/ – Since first joining the IRONMAN® circuit in 2012, Mont-Tremblant and its neighboring communities have become the triathlon community’s preferred destination, attracting top professionals and age-group athletes alike, here to race in Québec’s Laurentians every summer. As of 2024, Événements sportifs Mont-Tremblant and...

Events

Press Releases

Triathlon

July 31, 2023

Gran Fondo National Series Reveals 2023 Gran Fondo National Championships Commemorative Jersey

(Gettysburg, PA – July 31, 2023) /ENDURANCE SPORTSWIRE/ - The SUAREZ Gran Fondo National Series today revealed the design for the 2023 USA Cycling Gran Fondo National Championships commemorative jersey. Age group competitors who win their category will receive an official Stars and Stripes National Championships jerseys from USA Cycling,...

Cycling

Events

Press Releases

Sponsorship

July 31, 2023

DeFeet Evo Jet™ Sets New Benchmark In Aerodynamics

Hildebran, NC, July 31, 2023 /ENDURANCE SPORTSWIRE/ – DeFeet announces extensive wind tunnel testing results have concluded that the company’s new EVO Jet™ sock demonstrates market leading aerodynamics. “Perhaps the biggest discovery in cycling aerodynamics in recent years has been that socks are in fact the lowest cost way to increase...

Press Releases

Products

Wire Syndication

July 30, 2023

Trevor Foley (USA) and Giorgia Priarone (ITA) Top The Competition At 2023 IRONMAN 70.3 Maine Triathlon

AUGUSTA, Maine/ENDURANCE SPORTSWIRE/ - Maine’s State Capital and scenic Kennebec County played host to the 2023 edition of IRONMAN® 70.3® Maine triathlon, North American TriClub Championship – Northeast. The event saw Trevor Foley (USA) put in blistering fast splits across the swim, bike and run to capture the overall victory with a...

Events

Press Releases

Triathlon

July 30, 2023

In Memory of Magnus White

/ENDURANCE SPORTSWIRE/ - It is with an extremely heavy heart that we share the news that 17-year-old Magnus White has passed away in a training accident. On Sunday, July 30th, we received the news that National Team athlete Magnus White was struck by a car on a bike ride in...

Cycling

Industry Buzz

Press Releases

July 28, 2023

USA Triathlon Foundation Supports i-tri as First Founding Impact Partner

COLORADO SPRINGS, Colo./ENDURANCE SPORTSWIRE/ – The USA Triathlon Foundation today announced a five-year partnership with nonprofit i-tri, which empowers adolescent girls through the sport of triathlon, as the organization’s first Founding Impact Partner. Through the Founding Impact Partner Program, the USA Triathlon Foundation supports community organizations dedicated to making an impact related...

Giving

Press Releases

Triathlon

July 28, 2023

Team USA Announced for Challenge Stellina

/ENDURANCE SPORTSWIRE/ – The 35th edition of Challenge Stellina, a 14.3K uphill race with 1500 meters of climb, will take place Sunday, August 27, 2023, in Susa, Italy, and Team USA will be on the start line. Four athletes, two men and two women, along with one staffer, will travel...

Events

Press Releases

Running

July 28, 2023

Live tracking at Expedition Colorado 2023

Front Royal, Va. /ENDURANCE SPORTSWIRE/ – In 2023, Expedition Colorado will be partnering with Enabled Tracking, a real-time GPS timing and tracking service provided by Adventure Enablers, in order to help provide athletes with an enhanced expedition racing experience. The event starts on August 3rd, 2023. Expedition Colorado is a...

Events

Press Releases

Products

July 28, 2023

Alpha Win Introduces Brand New Triathlon at Historic Wildflower Location

(July 25, 2023) /ENDURANCE SPORTSWIRE/ - Alpha Win is proud to announce that it will be adding a new race to its California lineup at the location of the historic Wildflower Triathlon. The Alpha Win Lake San Antonio Triathlon will be held Saturday, April 27, 2024, in Bradley, California. Previously...

Cycling

Events

Press Releases

Running

Triathlon