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

August 18, 2022

Sportive Breaks comes on board for 2023 UCI Cycling World Championships

/ENDURANCE SPORTSWIRE/ – Global travel and VIP experience provider Sportive Breaks, part of Destination Sport Experiences, have been appointed as the Official Fan and Amateur Participant Travel Provider of the 2023 UCI Cycling World Championships, which are set to take place in Glasgow and across Scotland from 3rd to 13th August...

Cycling

Events

Press Releases

Sponsorship

August 18, 2022

EventHub Returns as Official Expo Software Partner for 2023 Running USA Industry Conference

(Aug. 18, 2022)/ENDURANCE SPORTSWIRE/ – Running USA announces that EventHub, the leading Endurance Sponsorship and Expo Platform, will continue in the role of Official Expo Software Partner for the 19th Running USA Industry Conference at the Hyatt Regency Denver at Colorado Convention Center set for Feb. 12-14, 2023. Registration is now...

Press Releases

Products

Running

Sponsorship

Trade Shows

August 18, 2022

Tanner Putt to Direct US National Team for Tour de L’avenir and the U23 UCI Road World Championships

Salt Lake City, Utah. (August 18, 2022) /ENDURANCE SPORTSWIRE/ - From 18th to 28th August 2022, the Tour de L'avenir will cross France from West to East, justifying its reputation as the Tour de France for young people. The victories of the Colombian Egan BERNAL in 2017, and the Slovenian...

Cycling

Events

Press Releases

August 18, 2022

The Outspoken Women in Endurance Sports Awards are back with an expanded reach to celebrate the contributions of even more women in endurance sports.

Victoria, BC – August 18, 2022/ENDURANCE SPORTSWIRE/ – Nominations are now open for the 2022 Outspoken Women in Endurance Sports awards with categories focused on women in triathlon and gravel cycling. The Women in Endurance Sports Awards celebration will be held in Tempe, Arizona at 11:00am Sunday, November 13th, 2022. The awards...

Awards

Cycling

Press Releases

Trade Shows

Triathlon

August 17, 2022

Two Asheville Businesses Nominated to Receive Honors at the US Subscription Box Awards

Asheville, NC ­/ENDURANCE SPORTSWIRE/ – The RunnerBox and Sparkle Hustle Grow, both women-owned, Asheville based businesses have been nominated for top honors at this year’s US Subscription Box Awards, a competition which selects the top three subscription boxes across 25 categories and relies on consumer votes to crown a final winner....

Awards

Press Releases

Running

August 17, 2022

XTERRA Germany Elite Preview

August 17, 2022 /ENDURANCE SPORTSWIRE/ -  XTERRA returns to Zittau, Germany for the 20th time with an action-packed weekend of Short Track and full distance off-road triathlon racing this Friday and Saturday, August 19-20. As the name suggests, Friday’s XTERRA Short Track race is a fast, multi-lap, made-for-TV event combining...

Events

Press Releases

Triathlon

August 17, 2022

Riders Around the World to Experience the Best Sights of Down Under with FulGaz Hope Cycle Tour of Australia

MELBOURNE, AUS/TAMPA, Fla. (August 17, 2022) ENDURANCE SPORTSWIRE/ - FulGaz®, The IRONMAN Group’s cutting-edge indoor virtual cycling app, announced today that cyclists from around the world will have the chance to experience the highlights of riding down under without leaving their homes with the Hope Cycle Tour of Australia. The...

Cycling

Giving

Press Releases

Products