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

November 8, 2022

Gruppo Announces Launch Of FuelFinder

Windsor, Ontario /ENDURANCE SPORTSWIRE/ – Gruppo Nutrition announces the launch of a tool that’ll make it easier for athletes to choose the nutrition product that best suits their needs, FuelFinder. Since 2006, Gruppo has been growing to encompass a wide array of sports nutrition and everyday protein drinks. That’s why they...

Cycling

Press Releases

Products

Running

Triathlon

November 4, 2022

Stages Cycling Black Friday Deals Start Monday, November 7

Boulder, CO – 4 November, 2022 /ENDURANCE SPORTSWIRE/ – Starting Monday, Nov. 7, Stages Cycling will release deals with deep discounts and incredibly low prices on indoor bikes, GPS cycling computers and power meters. Stages SB20 Smart Bike for $1799 The smoothest, most realistic and immersive virtual cycling experience will be available for...

Cycling

Press Releases

Products

November 3, 2022

FulGaz expands User Experience with New Enhancements

TAMPA, Fla. / MELBOURNE, Australia (November 3, 2022) /ENDURANCE SPORTSWIRE/ – FulGaz®, The IRONMAN Group’s cutting-edge indoor virtual cycling app, has released new enhancements to expand the user experience, including the launch of avatars and numerous new courses from IRONMAN® and IRONMAN® 70.3® Triathlon Series, Haute Route, and Epic Series events from around...

Cycling

Press Releases

Products

Triathlon

November 3, 2022

LIVALL launch the PikaBoost – for seamless and effective e-bike conversion

3rd November 2022, 2pm GMT, UK /ENDURANCE SPORTSWIRE/ – LIVALL, the team behind the world’s first smart cycling helmet, have expanded their smart cycle technology into the fast-growing e-bike market. The PikaBoost easily attaches to most bike categories and brands, transforming any bike into an e-bike in under 30 seconds. The tool-free...

Cycling

Press Releases

Products

November 3, 2022

ROUVY disrupts Cycling eSports with OmniMode technology using real 360° videos

Prague, Czech Republic / November 3rd, 2022 /ENDURANCE SPORTSWIRE/ – ROUVY’s unique digital platform is based on augmented geo-synced video routes which bring the real-life cycling and triathlon competition experience to your home. Over the last few years, ROUVY has given anyone the possibility to try La Vuelta, Tour de Suisse,...

Cycling

Press Releases

Products

Triathlon