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 (11)
) 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 2060, 10

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

How Bike Club’s decentralized cycling community changes everything

/ENDURANCE SPORTSWIRE/ - Originally conceived as an NFT project, Bike Club has quickly grown into something much bigger. As the world’s first decentralized cycling club and community that is free and open to everyone, the implications for the industry are massive. “Traditionally, bike clubs provided a foundational structure and grassroots...

Business

Press Releases

March 1, 2022

Colnago and L’Eroica Partner for the Next Three Years

Cambiago, Italy, March 1st 2022 /ENDURANCE SPORTSWIRE/ - It was destiny that Colnago and L’Eroica become partners. Both represent the deep and extraordinary passion for cycling, a sport that is increasingly widespread in every corner of the world. Both brands generate unique feelings and represent the success of  ‘Made in Italy’....

Business

Cycling

Press Releases

March 1, 2022

Destination Sport Experiences Announces Further Growth with the Acquisition of Cycling Travel Specialist Sportive Breaks

/ENDURANCE SPORTSWIRE/ - Hundreds of UK cyclists will benefit thanks to an asset purchase agreement between Sportive Breaks Ltd and Destination Sport Experiences.  The pandemic put unbearable pressure on the travel industry with two years of lockdowns and international travel restrictions, so being part of a much larger UK travel...

Business

Cycling

Press Releases