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

August 5, 2023

2023 UCI Cycling Worlds Day 4: Downhill Top Ten Finishes, Unpredictable Road Races, Close Track Racing, and Postponed BMX Freestyle Qualifications

August 5, 2023, GLASGOW /ENDURANCE SPORTSWIRE/ - A rainy fourth day of racing at the 2023 UCI Cycling World Championships led to several adventitious results for Team USA. BMX Freestyle athletes saw delays during their qualifiers, but each of the road races and downhill events proceeded as planned. Racing stayed...

Cycling

Events

Press Releases

August 5, 2023

Brownlee Fitness and Challenge Family Unite to Redefine the Triathlete Race and Training Experience via TrainingPeaks

/ENDURANCE SPORTSWIRE/ - In a collaboration announced today, Brownlee Fitness and Challenge Family have joined forces to create the ultimate race and training experience for triathletes across the globe, delivered via TrainingPeaks. Drawing on the expertise of two of the UK's greatest triathletes, Alistair and Jonny Brownlee, this collaboration marks...

Business

Press Releases

Triathlon

August 4, 2023

Valente Earns Gold on the Track, the Juniors Race Downhill Finals, and the Americans Complete the First Gran Fondo Event of the Week

August 4, 2023, GLASGOW /ENDURANCE SPORTSWIRE/ - Day two of the 2023 UCI World Championships saw racing at the Perth Gran Fondo course, the Fort William Downhill track, and the Sir Chris Hoy Velodrome. Track The second day at the Sir Chris Hoy Velodrome opened with the Women’s Team Pursuit...

Cycling

Events

Press Releases

August 4, 2023

Valente Wins 2023 World Championship Scratch Race

GLASGOW /ENDURANCE SPORTSWIRE/ - During the evening session of the second day at the Sir Chris Hoy Velodrome, Jennifer Valente (San Diego; TWENTY24 Pro Cycling) tackled her first individual event, the Women’s Scratch Race. The 40-lap race was action-packed, with attacks breaking up the group in the latter half of the...

Cycling

Events

Press Releases

August 4, 2023

Cape Cod Coffee Releases a Special Edition Coffee in Honor of Rick and Dick Hoyt

FALMOUTH, Mass. /ENDURANCE SPORTSWIRE/ – In anticipation of the ASICS Falmouth Road Race, sponsor Cape Cod Coffee has released a special new roast that pays tribute to two of the most iconic participants in the famous road race. The Coffee for a Cause program has chosen The Hoyt Foundation, which was...

Giving

Press Releases

Products

Running

August 4, 2023

Media Alert – “The Long Swim, Cycle, and Run to Freedom” Documentary Featuring Xylon Van Eyck Now Available

Atlanta, GA/ENDURANCE SPORTSWIRE/ – In a captivating and inspiring documentary, "The Long Swim, Cycle, and Run to Freedom," viewers are taken on a remarkable journey through the life of Xylon Van Eyck, a South African native whose resilience, determination, and passion for creativity have shaped his extraordinary story. Witness Xylon's compelling journey...

Press Releases

Products

Triathlon

August 4, 2023

Australia’s Favourite 24 Hour Adventure Race Celebrates Two Decades

/ENDURANCE SPORTSWIRE/ – The Hells Bells 24 hour adventure race celebrates 20 years of competition on the Sunshine Coast of Queensland this coming weekend (August 5-6th). Few adventure races anywhere in the world achieve this longevity and consistency, and the race is one of the keystones of Australian adventure racing....

Cycling

Events

Press Releases

Running

August 4, 2023

Midwestern team Rib Mountain Racing wins 2023 Maine Summer Adventure Race

/ENDURANCE SPORTSWIRE/ – The 45 teams participating in the 2023 Maine Summer Adventure Race, a nonstop, 24-hour endurance event that took place in coastal Maine from 22 to 23 July, spent a lot of time on the beach. Unfamiliarity with the terrain was no obstacle to Rib Mountain Racing, a...

Events

Press Releases

August 3, 2023

The First Day of the World Championships Kicked Off With the Track Events and the Downhill Qualifiers in Scotland

August 3, 2023, GLASGOW .ENDURANCE SPORTSWIRE/ - The 2023 UCI Cycling World Championships kicked off on Thursday with several Endurance and Sprint Track events as well as the Downhill Qualifiers for the Juniors. With Team USA being represented in the Men’s Team Pursuit, Men’s and Women’s Team Sprint, Women’s Individual...

Cycling

Events

Press Releases