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

April 19, 2023

Aleck Launches the First True Wireless, Near-Ear Audio and Comms for Cyclists

Monterey, CA (Apr. 19, 2023) /ENDURANCE SPORTSWIRE/ – Today marks the launch of Aleck’s highly anticipated Kickstarter presale of the new Aleck Punks, the bike industry’s first true wireless, near ear audio and communication system for cyclists. The Punks securely attach to helmet straps and deliver crystal clear sound and unlimited-range...

Cycling

Press Releases

Products

April 19, 2023

CamelBak® Expands Legendary M.U.L.E. Family with Spring 2023 Mountain Bike Collection

PETALUMA, Calif. (April 19, 2023) /ENDURANCE SPORTSWIRE/ – CamelBak®, the global leader in award-winning personal hydration products, launches all-new and redesigned members in its legacy line of M.U.L.E. hydration packs as part of its Spring 2023 collection. These new models include the M.U.L.E.® 5 Waist Pack and Mini M.U.L.E.® hydration pack, which round...

Cycling

Press Releases

Products

Triathlon

April 18, 2023

Cycling Time Trials (CTT) launches major update to recognise road bike time trialling as its own category

/ENDURANCE SPORTSWIRE/ – Cycling Time Trials (CTT) today launches major new website functionality that will seamlessly integrate road bikes into all events, but crucially separate them into their own category in the results. Riders who choose a standard road bike with drop handlebars and spoked wheels over a dedicated TT bike...

Cycling

Press Releases

Products

April 18, 2023

Saris Announces New Rack Products and Innovations for Spring/Summer 2023

MADISON, Wis. (April 18, 2023) /ENDURANCE SPORTSWIRE/ - Saris, manufacturer of world-class bike racks, trainers, storage and infrastructure, announces a number of new product offerings and a few additions to their most popular collections for the spring/summer season. Just in time for warmer temps, Saris products can now accommodate an...

Cycling

Press Releases

Products

Triathlon

April 17, 2023

Aleck’s Tocsen Crash Sensor Now Available to Cyclists in U.S. and Canada

South Lake Tahoe, CA (Apr. 17, 2023) /ENDURANCE SPORTSWIRE/ - Following their recently announced acquisition of impact detection technology company Tocsen, Aleck®, the industry-leading maker of wireless helmet audio systems for outdoor sports, announced today that Europe’s best-selling helmet crash sensor is now available in the U.S. and Canada. Aleck’s...

Business

Press Releases

Products

April 16, 2023

New Tools and Resources Unveiled on LA New Product Development Team’s Website for Inventors and Entrepreneurs

Shreveport, Louisiana, April 16, 2023 /ENDURANCE SPORTSWIRE/ - We are thrilled to announce the launch of new tools and resources on the LA New Product Development Team's website aimed at helping inventors, entrepreneurs, and product developers navigate the complex world of product development. Our newly added "Tools" section offers a...

Business

Press Releases

Products

April 14, 2023

Showcased

Multiple Bike Brands Now Using Fitted To Optimize Wholesale B2B Experience

Eagle, Idaho (April 14, 2023)  /ENDURANCE SPORTSWIRE/ – Fitted– the all-in-one B2B sales platform for a wide range of outdoor brands/retailers – continues to build on its recent move into the cycling realm with multiple major bike brands adopting their platform. In recent months Fitted, has partnered with Berria, Lee Cougan,...

Business

Cycling

Press Releases

Products

Triathlon

April 14, 2023

Chasing Watts makes it easier to share GPX files with everyone on your ride

/ENDURANCE SPORTSWIRE/ – Chasing Watts, the leading group ride app for cyclists, has just made it easier than ever for ride leaders to share a GPX route file with everyone on their ride. The latest update also makes it easier for anyone joining the ride to download or sync the GPX...

Cycling

Press Releases

Products