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

March 7, 2022

Pic2Go Partnered with The Ventura Marathon to deliver Race Day Photos and Rich Finisher Galleries!

/ENDURANCE SPORTSWIRE/ - The fast and scenic Ventura Marathon returned this year, offering a point-to-point marathon (and half marathon) with the perfect amount of downhill starting in Ojai and ending in Ventura. This year the organizers have partnered with Pic2Go to enhance the participants’ experience with auto-delivered free race day...

Press Releases

Products

Running

Sponsorship

March 4, 2022

Kane Footwear collaborates with Brian Mazza to launch first athlete-designed shoe

Westport, CT (March 4, 2022) /ENDURANCE SPORTSWIRE/ - Kane Footwear is releasing their first collaborative design of the Revive recovery shoe with athlete and entrepreneur Brian Mazza. The shoe features earth tones and a printed message on the sole of the shoe that reflects Mazza's story and mission: Nothing Changes if Nothing...

Business

Press Releases

Products

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