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

November 18, 2021

Bioracer UK Launches to Roll Out Custom Cycling Speedwear For All

/ENDURANCE SPORTSWIRE/ - Founded 35 years ago in Belgium, the spiritual home of cycling, Bioracer Speedwear has a strong heritage of designing, innovating and producing speedwear for cyclists to help maximise performance and comfort in the saddle. Over the past 20 years the custom clothing has been distributed in the UK...

Business

Cycling

Press Releases

November 18, 2021

Showcased

Quintana Roo introduces Fit-Ready build service

Chattanooga, TN  (Nov. 18, 2021) /ENDURANCE SPORTSWIRE/ - Quintana Roo announces the debut of Fit-Ready, an industry first that delivers a QR V-PR triathlon bike to a customer’s home, built to their exact fit requirements, making it truly set up to their fit coordinates from the moment it arrives in their...

Cycling

Press Releases

Products

Triathlon

November 18, 2021

‘The Digital Swiss 5’ kicks off tomorrow – The Start List and Where to Watch

Zurich, Switzerland / November 18, 2021 /ENDURANCE SPORTSWIRE/  PRO RACE FORMAT Athletes will compete in five digital races of about one hour each (the first four being lapped races) in Swiss cities. Each team is named by  the respective host cities of Lucerne, Lugano, Lausanne, Basel and Zurich. With a...

Cycling

Events

Press Releases

Triathlon

November 18, 2021

Life Time Foundation Announces Commitment to Youth Movement with new “Get Kids Moving!” National Initiative

CHANHASSEN, Minn., Nov. 18, 2021 /ENDURANCE SPORTSWIRE/ - Life Time Foundation, the 501(c)(3) nonprofit charitable arm of Life Time (NYSE: LTH) today announced a massive commitment to improving children’s health with the launch of Get Kids Moving! The new youth movement focus will fund initiatives of schools and community organizations nationwide...

Events

Giving

Press Releases

November 18, 2021

Revelshine Sustainable Wines Partners With New WineShine Half Marathon

NAPA, Calif. /ENDURANCE SPORTSWIRE/ - The WineShine Half Marathon is thrilled to welcome Revelshine as the sustainable-premium-wine partner for its 2022 inaugural event. Revelshine, a premium, world-class wine in a sustainable, portable and recyclable aluminum bottle, will provide a bottle of wine to each half-marathon participant in the July 16, 2022...

Press Releases

Running

Sponsorship

November 18, 2021

Bearclaw Bicycle Co. Named ‘Ultra Series’ Sponsor for 2022 Michigan Gravel Race Series

/ENDURANCE SPORTSWIRE/ -As part of the upcoming 2022 Michigan Gravel Race Series (MGRS), Bearclaw Bicycle Co. has renewed its sponsorship for the second year running as the official Ultra Series sponsor. The Bearclaw Bicycle Co. Ultra Series includes seven 100+ mile gravel bike races among the 15 events within the...

Cycling

Events

Press Releases

Sponsorship

November 18, 2021

Brent Bookwalter joins the Pro Cyclist Foundation

Denver, Colorado, November 18, 2021 /ENDURANCE SPORTSWIRE/ - The Pro Cyclist Foundation has named Brent Bookwalter as a Vice Chairman for the Foundation's Board of Directors. Bookwalter will also be providing consulting and advisory work for the Foundation's Athlete Services Committee. Bookwalter recently retired from a 16-year career as a...

Business

Cycling

Press Releases

November 17, 2021

ELITE & Zwift Partner up for Midweek Mountain Massif TT

FONTANIVA, ITALY, November 17th, 2021 /ENDURANCE SPORTSWIRE/ - Elite Cycling and Zwift Insider are teaming up for two Thanksgiving Eve throw-downs in the mountains and you're invited. Midweek Mountain Massif TT What do you get if you cross a mountain race and a time trial? An absolutely intense, but highly...

Cycling

Events

Press Releases

November 17, 2021

Enduro MTB Training Announces Train to Ride: Performance and strength training for cycling and moto

/ENDURANCE SPORTSWIRE/ - Enduro MTB Training founder and long-time coach, racer, and trainer, Dee Tidwell, announces the expansion of his performance and strength training programs beyond the MTB discipline with Train to Ride, changing the way cyclists approach strength training. Train to Ride is now offering cycling-specific programs and plans for...

Business

Cycling

Press Releases