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

November 10, 2022

Orlando Selected to Host The 2024 U.S. Olympic Team Trials – Marathon

Orlando, FL /ENDURANCE SPORTSWIRE/ – Together with the Greater Orlando Sports Commission, the City of Orlando, and Orange County, Track Shack is thrilled to announce that Orlando will be the host city for the 2024 U.S. Olympic Team Trials - Marathon. The Trials will be Saturday, February 3, 2024, in downtown...

Events

Press Releases

Running

November 10, 2022

Super Sunday: GFNY closes 2022 with three races on same day

/ENDURANCE SPORTSWIRE/ GFNY Cozumel The 9th GFNY Cozumel is the largest bike race in the Americas south of NYC. The long course offers riders a flat and furiously fast 157km around the tropical paradise island of Cozumel. Like no other, the race combines panoramic views of the beautiful turquoise ocean...

Cycling

Events

Press Releases

November 10, 2022

Australia’s Capital City to Host Challenge Canberra 2023

/ENDURANCE SPORTSWIRE/ - Australia’s capital city is home to the country’s newest international middle distance triathlon with Challenge Family’s announcement today of Challenge Canberra, taking place on 26 November 2023. Long synonymous with triathlon, Canberra has become a preferred training destination for many with its extensive network of bike paths...

Events

Press Releases

Triathlon

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