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

February 23, 2023

National Cycling League Announces Strategic Partnership with Wahoo Fitness

Miami, FL. February 23, 2023 /ENDURANCE SPORTSWIRE/ – The National Cycling League, the first of its kind professional sports league built around values of diverse ownership, gender equality, technology, and sustainability, today announced a 2-year strategic partnership with leading endurance athlete fitness technology company Wahoo Fitness. The NCL’s two co-ed professional...

Cycling

Press Releases

Sponsorship

February 23, 2023

The Legend Expedition Race in Australia Starts the 2023 Adventure Racing World Series

/ENDURANCE SPORTSWIRE/ – This year’s Adventure Racing World Series spans 10 countries and the new Legend XPD race in Australia is the first, taking place from February 25th to March 4th. The expedition adventure race is based in Jindabyne, a popular alpine town that sits on the shores of the picturesque...

Events

Press Releases

February 22, 2023

IRONMAN Announces New 5150 Cartagena Triathlon Taking Place in Cartagena De Indias, Colombia

CARTAGENA, Colombia / TAMPA, Fla. (Feb. 22, 2023) /ENDURANCE SPORTSWIRE/ - IRONMAN announced today the addition of the 5150™ Cartagena triathlon in the city of Cartagena de Indias, Colombia on September 17, 2023. With a beautiful colonial port with so much history to discover, athletes will have the opportunity to...

Events

Press Releases

Triathlon

February 22, 2023

BikeExchange Partners with Blaupunkt E-Bikes for DTC, Retail Sales

Asheville, North Carolina (February 22, 2023) /ENDURANCE SPORTSWIRE/ – In an effort to simplify the buying process while also increasing their North American (NA) presence, renowned electronics brand Blaupunkt has signed an exclusive agreement with BikeExchange, the world’s biggest online marketplace for bikes and bike products: BEX is now the sole direct-to-consumer...

Business

Cycling

Press Releases

Products

Triathlon

February 22, 2023

2022 IRONMAN Athlete Choice Awards Announced for North American Region

TAMPA, Fla. (Feb 22, 2023) /ENDURANCE SPORTSWIRE/ – IRONMAN, today announced the North American regional results for the 2022 IRONMAN Athlete Choice Awards, highlighting the highest-scoring events in a variety of categories based solely on athlete surveys from all the 2022 IRONMAN® races across North America. Out of the all the...

Awards

Press Releases

Triathlon

February 22, 2023

rnnr Partners with Press Forward for PR and Communications Initiatives

REDLANDS, Calif. (February 22, 2023) /ENDURANCE SPORTSWIRE/ – rnnr and Press Forward PR are thrilled to announce that they’re partnering to help bring the brand’s hats, apparel, and accessories to runners across the country. rnnr was founded in 2019 by Kate and Justin Arsenault as a brand committed to creating products...

Business

Press Releases

February 22, 2023

Challenge Family and ROUVY Stand Together for Türkiye/Syria

/ENDURANCE SPORTSWIRE/ - Challenge Family and ROUVY are deeply moved by the earthquakes in Türkiye and Syria, where tens of thousands of people have lost their lives and many more have been injured or lost their homes and livelihoods. The people of these countries need help urgently and so ROUVY...

Cycling

Giving

Press Releases

Triathlon