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

June 14, 2023

GFNY Lourdes Tourmalet: Dutch and French win after 4064m of climbing

New York City, June 14, 2023 /ENDURANCE SPORTSWIRE/ – The famous pilgrimage town of Lourdes hosted the second edition of GFNY Lourdes Tourmalet this past Sunday. The racecourse was 157 km long with an elevation gain of 4064 m and included the legendary Pyrenées climbs Col d’Aspin and Col du Tourmalet....

Cycling

Events

Press Releases

June 14, 2023

“Get 10% Fitter” or your money back on Wattbike purchases

/ENDURANCE SPORTSWIRE/ – Wattbike is the original, indoor smart bike innovator, offering the most accurate and reliable training tools used by champions, athletes and fitness enthusiasts worldwide. With a mission to improve the health and fitness of every athlete in the world, Wattbike’s most recent campaign ‘Get 10% fitter, Guaranteed’ is their...

Cycling

Press Releases

Products

June 14, 2023

Cycling Time Trials Announce New Transgender Policy

14th June 2023, 9am BST /ENDURANCE SPORTSWIRE/ – The team at Cycling Time Trials (CTT) have today announced that transgender women (those who have transitioned from male to female) will no longer be eligible to ride in female competitions. CTT’s purpose is to facilitate and run time trials – where each...

Cycling

Events

Press Releases

June 14, 2023

UltraSignup Announces Courtney Dauwalter will join as Commentator for Broken Arrow Skyrace Livestream

Nashville, TN/ENDURANCE SPORTSWIRE/ – UltraSignup, the leading online marketplace and registration platform for trail and ultra-running events, is thrilled to announce the addition of renowned ultra-runner Courtney Dauwalter as a commentator for this weekend’s livestream of the 23K at The Broken Arrow Skyrace. Additionally, the UltraSignup team is partnering with Tommie Runz,...

Press Releases

Running

Sponsorship

June 14, 2023

Boulderthon® Debuts New Course That Will Start And Finish In Downtown Boulder

BOULDER, Colo./ENDURANCE SPORTSWIRE/ – Boulderthon®, the fastest-growing running series in Colorado, has announced a paramount change to their course for the Oct. 8 event. Runners will now start and finish off the Pearl Street Mall in the heart of Downtown Boulder, an unprecedented milestone for a marathon race series in Boulder....

Events

Press Releases

Running

June 14, 2023

International Field at Lotto Challenge Gdańsk This Weekend

/ENDURANCE SPORTSWIRE/ – With a start list of over 40 professional athletes at Lotto Challenge Gdańsk, some exciting racing is guaranteed for the Polish middle distance race this Sunday. Heading the field and fresh from his win at Challenge Geraardsbergen last weekend is Menno Koolhas (NED). Also doing back-to-back races are...

Events

Press Releases

Triathlon

June 14, 2023

tentree opens its first retail store in Washington D.C.

Vancouver, BC (June 14, 2023) /ENDURANCE SPORTSWIRE/ - tentreeⓇ, an earth-first lifestyle apparel brand whose mission is to plant 1 billion trees by 2030 to drastically reduce climate change, has opened its first-ever US retail store in Washington, D.C’s Shaw neighborhood. Since its start in 2012, each tentree purchase has...

Events

Press Releases

June 14, 2023

US Trail Running Conference Webinar Highlights How Technology Can Help Grow Races

Nailsworth, England /ENDURANCE SPORTSWIRE/ – Leveraging Technology was the subject for the fourth webinar in an eight-webinar series produced by the US Trail Running Conference presented by Marathon Printing, and was live on Thursday, May 25. The webinar series is free for all race directors and event organizers to access, and...

Press Releases

Running

Trade Shows

June 14, 2023

Frontwave Rides On With Bike The Coast As Title Sponsor

OCEANSIDE, Calif. /ENDURANCE SPORTSWIRE/ – Bike The Coast, Southern California’s premier coastal cycling event, has announced that Frontwave Credit Union has once again signed on as the ride’s title sponsor for 2023 and 2024. The longstanding partnership signals Frontwave’s continued dedication to the local community and events that bring visibility to...

Cycling

Events

Press Releases

Sponsorship