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

August 6, 2023

The United States Finishes 11th and 20th in the Elite Men’s Road Race

August 6, 2023, GLASGOW /ENDURANCE SPORTSWIRE/ - Day four of the highly anticipated 2023 UCI Cycling World Championships witnessed a thrilling showcase of grit as the Elite Men’s Road Race took center stage in George’s Square. The United States earned another medal on the track and had nine riders qualify...

Cycling

Events

Press Releases

August 6, 2023

Laidlow and Langridge Claim Titles at Inaugural Challenge London

London, UK /ENDURANCE SPORTSWIRE/ - Sam Laidlow (FRA) and Fenella Langridge (GBR) claimed the first-ever Challenge London titles as over 5,000 triathletes took part in the world’s biggest city centre triathlon. 2023 marks the first edition of the new-look event, formerly known as London Triathlon, and the first time the...

Events

Press Releases

Triathlon

August 6, 2023

Valente Goes Two for Two: Winning Medals in Friday’s Scratch Race and Sunday’s Elimination Race

August 6, 2023, GLASGOW /ENDURANCE SPORTSWIRE/ - On the fourth day of the 2023 UCI Cycling World Championships in Glasgow, Jennifer Valente (San Diego; TWENTY24 Pro Cycling) raced her second individual event of the week, the Women’s Elimination Race. She earned bronze, making this her 19th World Championship medal. With...

Cycling

Events

Press Releases

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 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

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