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 (11)
) 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 790, 10

July 8, 2024

How do the pros fuel to win at the Tour de France, and how does it apply to your riding? Find out with Hexis and TrainingPeaks at their free webinar “Fuelling 4 Tour de France Victories: Discover How Champions Eat to Win”.

8th July 2024 /ENDURANCE SPORTSWIRE/ - With the Tour de France getting off to such a fast and furious start in Italy this week, there will have been more pressure than ever on the riders and their teams to get their fuelling strategies spot on. On day one Team DSM-Firmenich...

Business

Cycling

Events

Press Releases

July 4, 2024

Brownlee Racing is Launched and Secures Final supertri Team Franchise

LONDON, UK/ENDURANCE SPORTSWIRE/ - Three-time Olympic medallist Jonny Brownlee (34) has today teamed up with his double-Gold winning brother, Alistair (36) to launch Brownlee Racing, a new endurance racing team. The first sporting engagement for Brownlee Racing will be acquiring and competing as one of four new teams in the...

Business

Press Releases

Triathlon

July 3, 2024

Showcased

All-new Parlee Taos Gravel Bike Brings Next-Level Traction

JULY 3, 2024 - Beverly, MA /ENDURANCE SPORTSWIRE/ - “Gravel” has become more than just riding on dirt roads. More than a way to escape traffic and routine. It’s how we immerse ourselves in our environment, and the all-new Parlee Taos delivers an entirely new level of compliance that not only...

Business

Cycling

Press Releases

Products

July 3, 2024

Registration now open for GranFondo Whistler – Riviera Nayarit 2025

Mexico City, July 2, 2024. /ENDURANCE SPORTSWIRE/ – We are pleased to announce the first edition in Mexico of the GranFondo Whistler – Riviera Nayarit, which will take place on Saturday, April 5, 2025, in Bahía de Banderas, Nayarit. The GranFondo Whistler, held for 15 years in Canada, is one of...

Business

Cycling

Events

Press Releases

July 1, 2024

Denver Colfax Marathon Celebrates Race Director Creigh Kelley

DENVER, CO /ENDURANCE SPORTSWIRE/ - The Denver Colfax Marathon celebrates the career of its longtime race director, Creigh Kelley, as he transitions into a race director emeritus role. Kelley, who has been with the marathon since its inception 18 years ago, is stepping away from his official race director duties...

Awards

Business

Events

Giving

Press Releases

Running

Triathlon

June 28, 2024

Favorite Bikes Launches Brand New Hybrid CSC ST To COSTCO Canada Online

Favorite Bikes, Los Angeles, California /ENDURANCE SPORTSWIRE/ - Favorite Bikes, a pioneer in electric bike technology, proudly announces the launch of its newest model, the Hybrid CSC ST, available online at Favorite Bikes and through the newly formed relationship with Costco’s Canada and their online store for $1999 CAD. This cutting-edge...

Business

Cycling

Press Releases

Products

June 28, 2024

Ultra X Announces Big Summer Sale

/ENDURANCE SPORTSWIRE/ - Ultra X, renowned for organizing world-class ultra-marathons, is thrilled to announce the launch of its highly anticipated Big Summer Sale. This exclusive sale offers participants a chance to enjoy a 20% discount on all 2024 events, making it the perfect opportunity to secure a spot in some...

Business

Events

Press Releases

Running

June 28, 2024

Hap Seliga Appointed President of Scott USA

/ENDURANCE SPORTSWIRE/ - SCOTT Sports, manufacturer and distributor of high-quality Bike and Outdoor equipment and apparel, welcomes industry veteran Hap Seliga as President of SCOTT USA, the United States subsidiary of SCOTT Corporation. Alongside teams based in Salt Lake City and Ogden, Utah, Seliga will work to drive growth in...

Business

Cycling

Press Releases