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

January 18, 2023

Stages Cycling Factory Install Now Available for Dual Sided Dura-Ace 9200

Boulder, CO – 18 December, 2022 /ENDURANCE SPORTSWIRE/ – Stages Cycling, a leading cycling technology company, announced Factory Install service is now available for Shimano’s latest 12-speed Dura-Ace 9200 cranksets. Stages Factory Install service allows customers to send their existing crankset to be converted into an accurate, reliable Stages Power Meter. Factory...

Business

Cycling

Press Releases

Products

January 18, 2023

Amanda Duke Boulet Named USABA Director of Sport Performance

COLORADO SPRINGS, Colo. /ENDURANCE SPORTSWIRE/ – The U.S. Association of Blind Athletes (USABA) is pleased to announce the hiring of Amanda Duke Boulet as director of sport performance, a new and integral position within the organization. Duke Boulet has been a leader in the U.S. Paralympic movement for the past 15...

Business

Press Releases

January 18, 2023

BibRave Boosts Missoula Marathon Social Following By More Than 28 Percent

Honolulu, HI /ENDURANCE SPORTSWIRE/ – BibRave, the leading-edge endurance and fitness marketing agency, worked with the Missoula Marathon to create a simple but effective sweepstakes to increase the race’s social following across all platforms and boost engagement and other social media metrics. “We rely on BibRave to manage all of our...

Business

Press Releases

Running

January 17, 2023

Rebranded RUN Varsity Aims to Support Teenagers Moving

PITTSBURGH /ENDURANCE SPORTSWIRE/ – P3R has announced that 4RUN2 Varsity has rebranded to RUN Varsity. The rebrand is designed to be more inclusive of ALL youth in the area. RUN Varsity adds to P3R’s robust programming to motivate any and all to MOVE and will continue to support, educate and encourage teenage...

Business

Giving

Press Releases

Running

January 17, 2023

Frederic Funk and Marten Van Riel join ROUVY as Brand Ambassadors for 2023

Prague, Czech Republic / January 17th, 2023 /ENDURANCE SPORTSWIRE/ – Whether one’s goal is just to stay fit or to make the next race podium, ROUVY’s unique virtual racing platform is there to make the training process fun and engaging. With thousands of popular cycling and tri spots around the world,...

Press Releases

Sponsorship

Triathlon

January 17, 2023

Challenge Family Welcomes First Race in Central Asia – Challenge Samarkand

/ENDURANCE SPORTSWIRE/ – Challenge Family enters Central Asia for the first time with the launch of Challenge Samarkand. The new middle distance race in Uzbekistan will take place on 16-17 September, working with the Uzbekistan Triathlon Federation to take the sport of triathlon in the region to the next level. "We...

Events

Press Releases

Triathlon

January 17, 2023

IRC Tire Selected as Official Tire of Unbound Gravel

Davis, CA /ENDURANCE SPORTSWIRE/ – IRC Tire is pleased to announce that they have been chosen as the official tire of Garmin Unbound Gravel presented by Craft, the premier gravel cycling event in the world. Unbound Gravel, known for its challenging terrain, requires tires that can withstand the rigors of off-road...

Cycling

Press Releases

Sponsorship

January 17, 2023

Life Time Presents Gripping, Original Docuseries on Inaugural Life Time Grand Prix presented by Mazda

Boulder, Colo., (Jan. 17, 2023)/ENDURANCE SPORTSWIRE/ – Life Time (NYSE: LTH), the nation’s premier healthy lifestyle brand, announces “Call of a Life Time,” a docuseries made up of six binge-worthy episodes that follows the elite women and men in the inaugural Life Time Grand Prix presented by Mazda. Launching on January 27,...

Cycling

Events

Press Releases

Products