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

September 21, 2023

GFNY Super Sunday in Bali and Ecuador

/ENDURANCE SPORTSWIRE/ - Hosted by the tourist village of Sayan-Ubud, the 5th GFNY Bali offered the 1200 riders a 132 km long course with 1824m of climbing on “The Island of the Gods”. Supported by hundreds of Bali’s Police monitoring intersections along the entire course for a true “BE A...

Cycling

Events

Press Releases

September 21, 2023

5th edition of GFNY Chile this Sunday

New York City, September 21, 2023 /ENDURANCE SPORTSWIRE/ - Viña Veramonte, located just outside the capital city of Santiago de Chile, will host the 5th edition of GFNY Chile, where riders will tackle a 127.9km long racecourse with 1832m of climbing, including infamous Muro de Tunquen with its 27% steep...

Cycling

Events

Press Releases

September 21, 2023

Team BendRacing/SkinDoctor wins US Adventure Race National Championship

/ENDURANCE SPORTSWIRE/ - Team BendRacing/SkinDoctor won the 2023 United States Adventure Racing Association National Championship, hosted at the Smugglers’ Notch Resort in Jeffersonville, Vermont, on September 15-16, 2023. The team of three from Bend, Oregon – Emily Caseria, Dusty Caseria, and Max King – completed the 122-mile course in nine...

Events

Press Releases

September 20, 2023

US Performance Academy Becomes Official Online Academic Partner of USA Cycling

Elkins, N.H. /ENDURANCE SPORTSWIRE/ – US Performance Academy (USPA) is thrilled to announce that it has become the Official Online Academic Partner of USA Cycling. USA Cycling is the national governing body for bicycle racing in the United States covering the disciplines of road, track, mountain bike, cyclo-cross, and BMX across...

Cycling

Events

Press Releases

Sponsorship

September 20, 2023

Final Short Track Race of the XTERRA World Cup LIVE this Thursday

/ENDURANCE SPORTSWIRE/ – The 5th and final Short Track race of the series is the last opportunity for XTERRA’s strongest and fastest to score crucial points ahead of the series finale when the XTERRA World Championship will decide the winner of the first ever XTERRA World Cup beneath the Brenta...

Events

Press Releases

Triathlon

September 20, 2023

Drever, Killam win XTERRA Whistler

WHISTLER, September, 2023 /ENDURANCE SPORTSWIRE/ – The town of Whistler welcomed triathletes from elite and multiple age group divisions to the start line of the second edition of XTERRA Whistler. This event not only concluded the 2023 Americas Tour Schedule but also stood as the fourth qualifying event in the XTERRA...

Events

Press Releases

Triathlon