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

March 15, 2023

REI Joins the Denver Colfax Marathon Sponsor Team

Denver, CO /ENDURANCE SPORTSWIRE/ - The Denver Colfax Marathon welcomes REI to their marathon sponsor line up to give athletes access to training support, knowledge, and merchandise like never before. “We’re beyond excited to have partnered with the Denver Colfax Marathon on their 17th anniversary,” said Josh Millward, REI’s Regional Manager...

Business

Events

Giving

Press Releases

Running

Sponsorship

March 14, 2023

Jeremy Dunn Named Bike Marketing Manager at SMITH

PORTLAND, Oregon (March 13, 2023) /ENDURANCE SPORTSWIRE/ - SMITH – global market leader in snow goggles and helmets and industry innovator across bike helmets, sport, lifestyle, and prescription eyewear – is excited to announce the appointment of Jeremy Dunn as Bike Marketing Manager. With over 15 years experience in the...

Business

Cycling

Press Releases

March 14, 2023

BikeExchange Signs as Sole Online Sales Platform for Basso, Berria, Lee Cougan

Asheville, North Carolina (March 14, 2023)/ENDURANCE SPORTSWIRE/ – If you’ve ever dreamed of owning a legendary custom Basso, stealthy Berria or iconic Lee Cougan bike, the process just got much easier in North America: Cycling Distribution Network (CDN), the US distributor of all three brands, has recently signed on with BikeExchange...

Business

Cycling

Press Releases

Products

Triathlon

March 14, 2023

Signa Sports United Expands Presence in North America with New Corporate Office in Park City, UT

(March 14, 2023 - Park City, UT) /ENDURANCE SPORTSWIRE/ - Signa Sports United’s (SSU) North American Bike Division, a leading provider of high-performance cycling products, including Nukeproof and Vitus, today announced the opening of its new corporate office in Park City, Utah. The office will serve as the hub for...

Business

Press Releases

March 13, 2023

National Cycling League Announces Broadcast Partnership with GCN+

Miami, FL, March 13, 2023 /ENDURANCE SPORTSWIRE/ – The National Cycling League (NCL), the first of its kind professional sports league built around 21st century values of diverse ownership, gender equality, technology, and sustainability, today announced a three-year broadcast partnership with GCN+. GCN+ is solely focused on bringing cycling fans the best...

Business

Cycling

Events

Press Releases

March 13, 2023

Showcased

Premier Treadmill Manufacturer Woodway USA® Partners with KinomapTM SAS

Paris, FR/Waukesha, WI (March 13th, 2023) /ENDURANCE SPORTSWIRE/ – Today, it was announced that Woodway USA, manufacturer of premier treadmills for runners around the world, has partnered with Kinomap, developer of a patented software application which offers HD video simulations of famous road races, running routes and scenic locations from across...

Business

Press Releases

Products

Running