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

May 24, 2022

Wattbike Continue to Innovate on their Popular Training App, Wattbike Hub

/ENDURANCE SPORTSWIRE/ – Wattbike is a brand going from strength to strength and is now inviting users to enjoy an even better experience when using the Wattbike Hub App. With significant improvements around useability and navigation, the new home screen makes the app easier to track and measure your performance improvements...

Cycling

Press Releases

Products

May 23, 2022

ROUVY Ghosts’ Comeback – 10 Virtual Pace Bots to make the indoor cycling session more fun

Prague, Czech Republic / May 23, 2022 /ENDURANCE SPORTSWIRE/ – ROUVY, is an application and platform that turns what was formerly known as mundane stationary training into a fun and motivating virtual adventure around the world. The overlaid 3D avatars and objects, atop the real-life geo-synced video footage, create a realistic...

Cycling

Press Releases

Products

Triathlon

May 23, 2022

Microsoft Teams integration for CorporateFitness.app released

May 23, 2022 /ENDURANCE SPORTSWIRE/ – CorporateFitness.app is proud to announce the immediate availability of its Microsoft Teams integration. The brand new Microsoft Teams integration brings your corporate step or fitness challenge right inside the Microsoft Teams app everyone is already using all day long! Using this new integration your team can...

Press Releases

Products

May 19, 2022

Boa Nutrition Teams Up with Star Triathlete and Top Ironman Competitor Sam Long

RALEIGH, N.C. (May 19, 2022)/ENDURANCE SPORTSWIRE/ – BOA Nutrition announced today the sports performance supplement company signed an endorsement deal with top American triathlete and IRONMAN champion, Sam Long. Long will serve as brand ambassador in the sport of triathlon for BOA Endure, a rapid hydration oral aerosol. The Boulder, Colo., native...

Press Releases

Products

Sponsorship

Triathlon

May 18, 2022

The Ultimate Run Passport: Rock ‘n’ Roll Running Series Announces 2023 Tourpass

TAMPA, Fla. (May 18, 2022)/ENDURANCE SPORTSWIRE/ – The Rock ‘n’ Roll® Running Series, the world’s largest road running series today announced details of the 2023 Rock ‘n’ Roll® Running Series TourPass. The TourPass is the best way for runners to lock in low rates and access to amazing Rock ‘n’ Roll...

Events

Press Releases

Products

Running

May 18, 2022

Lizard Skins Adds a Bold New Color to Iconic Northshore Grip

American Fork, Utah (May 18, 2022)/ENDURANCE SPORTSWIRE/ – Lizard Skins, a longtime industry leader in grips and handlebar tape, is adding a bold Lime Green color to its long-renowned Northshore grip line, which until now consisted mainly of neutral and earth tones. The Northshore is one of the Lizard Skins all-time best-selling...

Cycling

Press Releases

Products

May 17, 2022

Superzeros Launch High Protein Zero Sugar Cereal – A Premium Breakfast Choice That Will Keep You Fuller for Longer

/ENDURANCE SPORTSWIRE/ – ‘Wake Up to Cereal with Superpowers’ with the UK’s newest high protein zero sugar cereal – Superzeros. The breakfast cereal offers 10g protein, 0g sugar and 50% less carbohydrates in every serving and is currently offered in Cocoa and Apple & Cinnamon flavours. It is also nut free,...

Press Releases

Products