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 (21085)
) 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 440, 10

April 9, 2024

2024 Indoor: Off-Season Updates by ROUVY

Pause Subscription in new Loyalty Program Workout improvements Drafting modelling refined New routes including Oatman, Arizona on Route 66 New and retro bikes added to virtual garage Prague, April 9th/ENDURANCE SPORTSWIRE/ – ROUVY, the indoor cycling app that lets you ride real routes around the world, presents a bundle of product...

Cycling

Press Releases

Products

Triathlon

April 9, 2024

Introducing The Brand Leader’s Dynamic Online Presence

Greenville, SC – April 9, 2024/ENDURANCE SPORTSWIRE/ – The Brand Leader®, a renowned advertising, branding, and creative integrated marketing agency that creates what’s impossible to forget, launches their updated innovative website, ushering in a new era of brand engagement and connectivity. This dynamic online platform is designed to elevate user...

Business

Press Releases

Products

April 9, 2024

Liv Introduces the New Intrigue X Range

NEWBURY PARK, Calif. (April 9, 2024) /ENDURANCE SPORTSWIRE/ - Liv, the company dedicated to getting more women on bikes, today launched the new Intrigue X Advanced and Intrigue X series. Designed for intermediate and expert trail riders, the Intrigue X is a standout performance mid-travel trail bike, perfect for navigating...

Business

Cycling

Press Releases

Products

April 9, 2024

supertri E World Triathlon Championships powered by Zwift will be supported by Garmin products on the world stage

/ENDURANCE SPORTSWIRE/ - supertri E World Triathlon Championships powered by Zwift will be backed by the Garmin® ecosystem when it returns to the global stage on April 13. Garmin have been key to supertri E for the past three years, and is extending its support to again be at the...

Press Releases

Products

Sponsorship

Triathlon

April 9, 2024

Chargel Kicks Off with On-Site Samplings at Two California-Based Cycling Events: The Sea Otter Classic and The GranFondo San Diego

IRVINE, Calif. (April 9) /ENDURANCE SPORTSWIRE/ - Chargel®, a first-of-its-kind, delicious Gel Drink that delivers convenient and delightfully unexpected instant pre-workout energy before any workout with zero caffeine, today announced its April competitive race station lineup. Chargel will be showcasing its half drink, half snack, all delicious energy source at the...

Cycling

Press Releases

Products

Running

Wire Syndication

April 4, 2024

Personalised sports nutrition experts Hexis announce TrainingPeaks integration

London, 4th April 2024/ENDURANCE SPORTSWIRE/ – Hexis is the first app that dynamically predicts an athlete's nutritional needs, tailored to their exact workout requirements, to create a personalised plan. Since every athlete’s needs are unique, this removes the complexity and confusion of nuanced sports nutrition and replaces it with simple-to-follow personalised...

Cycling

Press Releases

Products

Running

Triathlon

April 2, 2024

Stromer Partners with The Sweet Spot to Make E-Bikes More Accessible

Vista, CA (April 2, 2024) /ENDURANCE SPORTSWIRE/ - Stromer, pioneer in Swiss e-bike technology, is proud to partner with The Sweet Spot Bike Leasing, a cycling fintech company, to offer long-term e-bike leasing and management across the United States. This new leasing option makes Stromer’s premium class 3 commuter e-bikes...

Business

Press Releases

Products

April 2, 2024

USA Triathlon and Fast Talk Laboratories Release Polarized Training Certification for Endurance Coaches

April 2, 2024 – Colorado Springs, Colorado, USA /ENDURANCE SPORTSWIRE/ - USA Triathlon, the Olympic governing body for the sport of triathlon in the United States, and Fast Talk Laboratories, experts on endurance sports training methods, have partnered to produce a Polarized Training Certification Course. The new Polarized Training Certification...

Business

Cycling

Press Releases

Products

Sponsorship

Triathlon