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

March 28, 2022

361° Europe Partner with Professional Belgian Triathlete Valerie Barthelemy

/ENDURANCE SPORTSWIRE/ - 361° Europe are delighted to be adding ‘Belgian Hammer’ and rising star, Valerie Barthelemy, to an already impressive roster of 361° sponsored professional athletes and ambassadors, including previous World Champion triathlete Katie Zaferes. The team at 361° Europe produces running trainers and apparel, designed to support all...

Press Releases

Running

Sponsorship

Triathlon

March 25, 2022

ŠKODA eMČR 2022 – The National Champions of the Czech Republic in Virtual Cycling are Řepa and Kvasničková

Prague, Czech Republic / March 25, 2022/ENDURANCE SPORTSWIRE/ - Vojtěch Řepa from the Spanish team, Equipo Kern Pharma and Eliška Kvasničková from SportRaces became the champions of the Czech Republic in virtual cycling hosted on ROUVY. Titles in the elite categories ŠKODA eMČR 2022 were fought for in a joint race...

Cycling

Events

Press Releases

March 25, 2022

The Pro’s Closet adds two leadership hires

LOUISVILLE, CO (March 25, 2022)/ENDURANCE SPORTSWIRE/ - The Pro’s Closet (TPC) is thrilled to announce that Kaitlin Cameron has joined the company as their new Chief Marketing Officer, and Paul Calandrella as their Vice President of Strategic Initiatives. Cameron joins TPC after serving as the VP of Global Consumer Marketing at...

Business

Cycling

Press Releases

March 25, 2022

OFX and Super League Triathlon Extend Partnership

LONDON/ENDURANCE SPORTSWIRE/ - Super League Triathlon (SLT) can today announce it has extended its partnership with OFX who will become the official Currency and Foreign Exchange partner of SLT. The agreement builds on the success of the partnership between OFX and Super League in 2021, and covers Arena Games Triathlon...

Press Releases

Sponsorship

Triathlon

March 25, 2022

OPEX Fitness Expands InsideTracker Partnership to Deliver Unparalleled Personalized Training Resources for Professional Coaches

SCOTTSDALE, Ariz. – March 25, 2022/ENDURANCE SPORTSWIRE/ - OPEX Fitness today announced a partnership with InsideTracker, the leading truly personalized performance and nutrition system, following a successful pilot program in 2021 that gave coaches and clients access to InsideTracker Pro, delivering science-backed nutrition and lifestyle recommendations based on blood, DNA...

Business

Press Releases

Products

March 24, 2022

British Cycling Brand Parcours Update Their Customisable Offering For 2022

/ENDURANCE SPORTSWIRE/ - It’s never been easier for cyclists to upgrade both the look and performance of their wheelset to match their favourite bike. Parcours have an even greater level of bespoke customisations on offer for 2022 which have been tried and tested by some of the world’s best athletes....

Cycling

Press Releases

Products

March 24, 2022

Bike.com Launches with New Premium Line of Denago eBikes

Dallas, TX (March 24, 2022) /ENDURANCE SPORTSWIRE/ - Bike.com is officially live! The online marketplace looks to become the one-stop-shop for both experienced bicyclists and those graduating from training wheels. They have created a community where anyone interested in riding can come to learn, explore and purchase a bike, while...

Cycling

Press Releases

Products