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

February 5, 2024

Are Collectives the New Privateer Programs in Gravel Racing?

/ENDURANCE SPORTSWIRE/ - Felt UN1TD launched this week, uniting the talents of gravel racers Dylan Johnson, Danni Shrosbee and Adam Roberge under one banner. “Watching how the Life Time Grand Prix and other gravel events have gone in the last few years, it’s clear that privateers are struggling against riders...

Business

Cycling

Press Releases

Sponsorship

February 5, 2024

Are you ready to Go Multisport?

New York, NY, /ENDURANCE SPORTSWIRE/ – We are pleased to announce the new release Go Multisport: Add Fun, Challenge & Exploration to Your World by endurance athlete Jennifer Strong McConachie. This all-in-one resource and first handbook for multisport athletes introduces the revolutionary concept of multisport and how it can help you expand...

Cycling

OSW Syndicated

Press Releases

Products

Running

SWW Syndication

Triathlon

February 5, 2024

Delivgear RVA Model 1

Amsterdam, 05.02.2024 /ENDURANCE SPORTSWIRE/ - Today, Delivgear is proud to unveil its latest innovation, the Delivgear RVA Model 1 – a state-of-the-art Bicycle Rear View Assistant designed to enhance the safety and awareness of cyclists on the road. With cutting-edge features and advanced AI technology, the Delivgear RVA Model 1...

Cycling

Press Releases

Products

February 4, 2024

2024 Cyclocross World Championships Concludes With Three Americans in the Top 20

TÁBOR, Czech Republic /ENDURANCE SPORTSWIRE/ - Sunday concluded with the Junior Men, U23 Women, and Elite Men at the 2024 UCI Cyclocross World Championships. Sixteen athletes represented Team USA on the world stage, with three individuals finishing in the top 20 of their respective categories. Junior Men David Thompson (New Canaan,...

Cycling

Events

Press Releases

February 3, 2024

Lopez de San Roman Earns Top Position for Team USA at 2024 Cyclocross World Championships

TÁBOR, Czech Republic /ENDURANCE SPORTSWIRE/ - The 2024 UCI Cyclocross World Championships continued Saturday with the Junior Women, U23 Men, and Elite Women. Team USA arrived on site ready to take on the muddy course. After the Junior Women’s race, the conditions changed dramatically, which resulted in many of the...

Cycling

Events

Press Releases

February 2, 2024

Team USA Kicks off 2024 Cyclocross World Championships in Tabor

TÁBOR, Czech Republic /ENDURANCE SPORTSWIRE/ - The team relay event kicked off the 2024 Cyclocross World Championships in Tabor, Czech Republic today. The course conditions were unpredictable with an icy frozen base, then a thin layer of slick mud on top. It left the riders on their toes while they...

Cycling

Events

Press Releases

February 2, 2024

Salinas – Ecuador Set to Host New 5150 Triathlon

- Organizers of the Marathon IRONMAN 70.3 Ecuador to host La Roche Posay 5150 Salinas Ecuador triathlon presented by Marathon scheduled to take place on Sunday, May 5, 2024; Registration is now available by visiting www.ironman.com/5150-salinas QUITO, Ecuador / TAMPA, Fla. (February 2, 2024) /ENDURANCE SPORTSWIRE/ – IRONMAN announced today that the...

Events

Press Releases

Triathlon

February 2, 2024

OOFOS and FootJoy Pair Up to Bring Active Recovery to The Golf Community

FootJoy x OOFOS, February 2, 2024 /ENDURANCE SPORTSWIRE/ – OOFOS, the global leader in Active Recovery footwear, and FootJoy, purveyors of the number one shoes and gloves in golf, announced today a partnership to provide the foundation of Active Recovery to today's modern golfer. The new FJ x OOFOS OOahh Sport...

Press Releases

Products