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

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

March 23, 2022

NCM Introduces Euro-Inspired Commuter E-Bike Line

Seattle, Washington (March 23, 2022) /ENDURANCE SPORTSWIRE/ - Since its inception in Germany in 2014, NCM, a Leon Cycle brand, has grown into one of Europe's most popular e-bike brands, and they’ve recently launched a new line of Class I e-bikes in the States that pay homage to that urban European heritage....

Cycling

Press Releases

Products

Triathlon

March 23, 2022

Showcased

Nutrition Coaching App, FuelIn, Announces Integration with Today’s Plan

(San Francisco, CA) /ENDURANCE SPORTSWIRE/ FuelIn announced today the integration of its nutrition coaching app with sports technology platform, Today’s Plan. This brings FuelIn one step closer to the mission of making personalized performance nutrition coaching available to all athletes around the world. The FuelIn program takes the complex world...

Press Releases

Products

March 22, 2022

iFIT Adventures Launches, Allowing Members to Travel to Destinations First Discovered Through iFIT Workouts

Logan, Utah /ENDURANCE SPORTSWIRE/ - iFIT, one of the global leaders in connected fitness software, content, and equipment, today announced the launch of iFIT Adventures – a new series of in-person travel fitness experiences that explore destinations around the globe, bringing iFIT’s favorite, most-streamed Global Workouts to life. Led by...

Press Releases

Products

March 21, 2022

361° Europe Launch The Fierce 2 – A Do-It-All Trainer For Under £105

/ENDURANCE SPORTSWIRE/ - 361° have designed the Fierce 2 for all runners, who are seeking performance with style and comfort in a functional shoe they can wear throughout the day. The upper has been reimagined to improve breathability, stretch, and support to allow the foot to perform all day. A...

Press Releases

Products

Running

Triathlon

March 17, 2022

Joe Friel Launches Online Learning Experience, The Craft of Coaching, with Fast Talk Laboratories

March 17, 2022 /ENDURANCE SPORTSWIRE/ - Boulder, Colorado, USA – Joe Friel, the world’s most trusted personal cycling and triathlon coach, has launched a new online learning experience to help endurance sports coaches find more success. The Craft of Coaching is Joe Friel’s ultimate guide to becoming a better, happier,...

Cycling

Press Releases

Products

Triathlon