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

October 20, 2022

GFNY Florida: bike race and marathon

/ENDURANCE SPORTSWIRE/ - The 2nd GFNY Marathon Florida Sebring offers runners a full and half marathon. Start and finish take place at the Barn at Paso Fino. The course is flat and lightning fast on roads dedicated specifically for GFNY athletes. The USATF measured course is not only a Boston...

Cycling

Events

Press Releases

October 20, 2022

National Cycling League Announces Medalist Sports Partnership and All-Star Leadership Team

(New York, NY, October 20, 2022) /ENDURANCE SPORTSWIRE/ - The National Cycling League (NCL) has partnered with Medalist Sports and gathered the top talent in event production and sports entertainment as it prepares to launch America’s newest professional league sport in 2023. “You need a great team to bring new...

Business

Cycling

Events

Press Releases

Sponsorship

October 19, 2022

Correa and Melo win GFNY Bento Gonçalves

New York City, October 19, 2022 /ENDURANCE SPORTSWIRE/ - Bento Gonçalves, located in the heart of Brazil's Sierra Gaúcha, hosted the first edition of GFNY Bento Gonçalves 2022 this past Sunday. The racecourse was 138.6 km long with 2957m of climbing. Pro cyclist Alex Melo (Maxel Cycling) took the win...

Cycling

Events

Press Releases

October 19, 2022

The countdown is on for the 2022 World Triathlon Championship Series Bermuda

Hamilton, BERMUDA - 19 October, 2022 /ENDURANCE SPORTSWIRE/ - Anticipation mounts as the World Triathlon Championship Series (WTCS) Bermuda makes its long-awaited return on 5 - 6 November, 2022, just under a month away. It is all hands-on deck to pull together an event of this magnitude, and both the...

Events

Press Releases

Triathlon

October 19, 2022

XTERRA Returns to Australia in 2023

October 19, 2022 /ENDURANCE SPORTSWIRE/ – XTERRA returns to Australia in 2023 with a World Championship qualifying event in the southwest coastal town of Dunsborough, Western Australia on the weekend of April 1-2, 2023. The inaugural XTERRA Australia - Dunsborough off-road triathlon starts with a 1.5-kilometer swim in the turquoise waters...

Events

Press Releases

Running

Triathlon

October 19, 2022

Gold Coast gets ready to host the first Adventure Racing World Series Oceania Championships

/ENDURANCE SPORTSWIRE/ – The first Adventure Racing World Series Oceania Championship race takes place in Gold Coast and its hinterland hills and rivers between October 21st and 23rd. The best Adventure Racers in Australia will arrive in the city for 36 and 24 hour races, combining river paddling, trekking, coasteering, beach...

Events

Press Releases

October 19, 2022

BibRave Drives Sell-Out Numbers for the IMT Des Moines Marathon

Portland, OR /ENDURANCE SPORTSWIRE/ – BibRave, the leading-edge endurance, and fitness marketing agency, has partnered with the IMT Des Moines Marathon for years, providing marketing services and custom program ideation that boost registration and enhance the race experience for participants. In 2022, BibRave provided comprehensive 12-month marketing services, including strategy and ideation,...

Events

Press Releases

Running

October 17, 2022

Taiwan to Host 2023 XTERRA Asia-Pacific Triathlon and Trail Run Championships

October 17, 2022 /ENDURANCE SPORTSWIRE/ With the recent loosening of COVID-related travel restrictions, it has officially been announced that Taiwan will host the 2023 XTERRA Asia-Pacific Championship on April 15-16, 2023 in a double-feature weekend that will also see the first ever XTERRA Asia-Pacific Trail Run Championship play out at...

Events

Press Releases

Running

Triathlon