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

March 3, 2022

Yamaha Bicycles Introduces Two New e-Bikes for the U.S. Market

Cypress, Calif. – March 3, 2022 //ENDURANCE SPORTSWIRE/ - Yamaha Motor Corp., USA, the pioneering brand in electric bicycles, is introducing two all-new, class 3, power assist bicycles: the Wabash RT and the CrossCore RC, e-Bikes built from the ground up with the all new Yamaha PWSeries ST drive unit,...

Cycling

Press Releases

Products

March 3, 2022

Cirrus Cycles’ Kinekt Partners with Dutch Cargo

BELLINGHAM, Wash. March 3rd, 2022 /ENDURANCE SPORTSWIRE/ - Cirrus Cycles, the maker of the KINEKT suspension post and KINEKT suspension stem, proudly announces the addition of Dutch Cargo, the well-known Australian and New Zealand distributor, thereby increasing product available to customers worldwide. “Though we’re a small company based in Bellingham, Washington,...

Business

Cycling

Press Releases

Products

March 2, 2022

Archer Components Launches New Paddle Remote for D1x Trail System

Scotts Valley, California (March 2, 2022) /ENDURANCE SPORTSWIRE/ - Archer Components continues to build on its winning formula of developing electronic shifting for any mechanical derailleur with the release of the new Paddle Remote for its renowned D1x Trail e-shifting conversion kit. The new remote -- which can be purchased individually or...

Cycling

Press Releases

Products

Triathlon

March 2, 2022

Lizard Skins Launches Their Latest Grip: The Strata

American Fork, Utah (March 2, 2022) /ENDURANCE SPORTSWIRE/ - Lizard Skins, a longtime industry leader in grips and handlebar tape, has a new grip offering: the ‘Strata’. The Strata is a single-clamp lock-on grip that offers a soft, comfortable feel with its mushroom-style fin design. The medium diameter of 32.25mm sets the...

Business

Cycling

Press Releases

Products

Triathlon

March 2, 2022

Stages Cycling Introduces New App – Upgraded Experience for SB20, Dash and Power Meters

(Boulder, CO – 1 March, 2022) /ENDURANCE SPORTSWIRE/ - Stages Cycling today announced its new app, Stages Cycling, which replaces Stages Link and adds new features and functionality for Stages SB20 Smart Bike, Stages Dash and Stages Power meters. The Stages Cycling app includes an expanded list of sensor support to combine...

Cycling

Press Releases

Products

March 1, 2022

Saucony® Wins Trifecta of Editor’s Choice Awards in Runner’s World Spring 2022 Shoe Guide

WALTHAM, MASS. (March 1, 2022)/ENDURANCE SPORTSWIRE/ - Global performance running lifestyle brand Saucony today announced that it has won three Editor's Choice Awards in the Runner's World Spring 2022 Shoe Guide. The completely redesigned Ride 15, the maximally cushioned Axon 2 and the light and speedy Peregrine 12 all rose to...

Awards

Press Releases

Products