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

November 9, 2022

2023 XTERRA World Championship Set for Sept. 23 in Trentino, Italy

/ENDURANCE SPORTSWIRE/ – The 2023 XTERRA World Championship off-road triathlon will return to Trentino, Italy for the second straight year on Saturday, September 23, at Lake Molveno. The new date, one week earlier than in 2022, comes almost exactly a month after the XTERRA USA Championship, where 58 slots will be...

Events

Press Releases

Triathlon

November 9, 2022

Sprint finish at GFNY Colonia- Uruguay

New York City, November 9, 2022 /ENDURANCE SPORTSWIRE/ – Colonia - Uruguay hosted the second edition of GFNY Colonia this past Sunday. The racecourse was 148.2km with an elevation gain of 1122m. Under clear skies with perfect temperatures yet strong 30km/h cross winds, the race started off fast. It was at...

Cycling

Events

Press Releases

November 9, 2022

Roark Run Amok Launches A Capsule Collection with Artist Travis Weller

LAGUNA BEACH, CA./ENDURANCE SPORTSWIRE/ - Roark announces the launch of a capsule collection created in collaboration with longtime co-conspirator and friend, the artist and ultra distance runner, Travis Weller. As part of Roark’s Run Amok collection, which provides a unique vision of trail running and functional activewear born from adventure...

Events

Press Releases

November 8, 2022

RunSignup October Industry Update

November 8, 2022 - Moorestown, NJ /ENDURANCE SPORTSWIRE/ - RunSignup, the leading registration provider for U.S. endurance events, provides an October industry update. Aggregated registration data continue to show signs of gradual improvement for the endurance race industry after the long tail effects from the pandemic. Although most events have...

Business

Cycling

Events

Press Releases

Running

Studies

Triathlon

November 8, 2022

The Shenandoah Epic Adventure Race is back for 2023

/ENDURANCE SPORTSWIRE/- Adventure Enablers is excited to open registration for its 2023 running of the Shenandoah Epic 24-hour adventure race. The race is in its 11th year and is located in Front Royal, Virginia. The adventure race will start on April 15, 2023. Registration opened to VIP participants on October...

Events

Press Releases

November 6, 2022

Approximately 2,000 Athletes Converge in Florida’s Panhandle for the 2022 Visit Panama City Beach IRONMAN Florida, Part of The VinFast IRONMAN U.S. Series

PANAMA CITY BEACH, Fla. /ENDURANCE SPORTSWIRE/ - The beautiful beaches and emerald-green waters of Panama City Beach, Fla. provided a stunning backdrop for the 2022 Visit Panama City Beach IRONMAN Florida triathlon, part of the VinFast IRONMAN U.S. Series, on Saturday, Nov. 5. Approximately 2,000 athletes kicked off their IRONMAN...

Events

Press Releases

Triathlon

November 6, 2022

More than 4,100 Participants Celebrated the 10th Anniversary of the EQT Pittsburgh 10 Miler

PITTSBURGH (November 6, 2022) /ENDURANCE SPORTSWIRE/ – EQT Pittsburgh 10 Miler, the ‘most Pittsburgh race ever,’ celebrated its 10th anniversary today with more than 4,100 participants. The 10-mile and brand new 10K course featured local bands and Pittsburgh-themed miles, including the Mister Roger’s Mile, Pittsburgh Foods Mile and City of Champyinz...

Events

Press Releases

Running