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 1990, 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