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

September 23, 2021

Enduro Bearings Launches New Maxhit™ Line; Zero Stack Headset First Product

Oakland, California (September 23, 2021) /ENDURANCE SPORTSWIRE/-- Enduro Bearings has long been renowned for solving problems associated with bicycle bearing performance and durability, and with the imminent launch of their new Maxhit™ headsets they’ve done it again. With the everchanging design of rigid and suspension bicycle frames, traditional components can...

Cycling

Press Releases

Products

September 22, 2021

Digit Bikes Introduces Unique, GOLD-Award-Winning Full Suspension Bike, with Integrated Shock Absorber

IRVINE, CA (Sept. 22, 2021) /ENDURANCE SPORTSWIRE/ -- Veteran bicycle industry engineer and entrepreneur Tim Lane launched Digit Bikes this month with a groundbreaking new suspension system, named ANALOG. Digit Bikes has crowdfunding their launch with a Kickstarter campaign. At time of writing, funding is 100% secured, and pre-orders will...

Awards

Cycling

Press Releases

Products

September 22, 2021

Kodiak Steps into New Territory in Fall ’21 Collection

Cambridge, Ontario, September 22, 2021 /ENDURANCE SPORTSWIRE/ -- Kodiak, the 110-year-old boot brand, is adding both more trail and urban inspiration to its Fall 2021 line. A new “sniker” collection that blends sneaker comfort and aesthetics with legitimate hiker performance, as well as several new urban boot styles highlight the...

Press Releases

Products

September 21, 2021

100%® Launches 2021 Peter Sagan Limited-Edition Collection in Time For World Championships and Paris-Roubaix

SAN DIEGO, Calif. – September 21, 2021 /ENDURANCE SPORTSWIRE/ -- 100%®, the San Diego-based sports performance company, has announced the launch of the 2021 Peter Sagan Limited Edition Collection.  Just in time for one of the most highly-anticipated Paris-Roubaix races and on the heels of Sagan’s victory in the Tour...

Cycling

Press Releases

Products

September 21, 2021

Marathon-Photos LIVE reaches USA

September 21, 2021 /ENDURANCE SPORTSWIRE/ -- Hot on the heels of its Live photography launch in the UK, world-leading endurance photo company MarathonPhotos.Live has launched its ground-breaking new service in the United States. Runners in San Francisco Marathon had their photos online within seconds of passing photographers – both on...

Press Releases

Products

Running

Triathlon

September 21, 2021

Lucyd SMART Eyewear Launches Lyte Sport

Miami, FL: Lucyd, the brand of Bluetooth-enabled sunglasses announces today the launch of its lineup of SMART eyewear designed for the sports market. In addition to its current assortment of lifestyle-focused designs, Lucyd is rolling out the “Lyte Sport” capsule collection of its popular Lyte frames, which offer a sleek...

Press Releases

Products

September 20, 2021

Introducing The Lyric™ Therapeutic Massager, An Evolution in Self-Care

SANTA MONICA, Calif., Sept. 20, 2021 – Today marks an evolution in self-care with the launch of the new Wi-Fi-enabled Lyric™ therapeutic massager. Say goodbye to ugly, aggressive and heavy massage guns made only for elite athletes. The stylishly designed Lyric was developed with everybody – and every body –...

Business

Press Releases

Products

September 20, 2021

Gold-medal rowers turn to Myovolt technology during Olympic preparation

In preparation for this year's Olympic Games, getting treatments for warm-up or recovery physiotherapy was often limited to a Zoom session. Add to this the stress of being in travel quarantine and it’s clear that many athletes were forced out of their comfort zone, with  stark changes to their routines....

Press Releases

Products