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 (8742)
) 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 6550, 10

September 23, 2021

Showcased

GFNY Santa Fe: Ferrara still wins post-pandemic

/ENDURANCE SPORTSWIRE/-- The second annual GFNY Santa Fe bounced back from the pandemic with a bang. The southern end of the Rocky Mountains made for spectacular racing in a high altitude setting with perfect racing weather. The 75-mile course included 7,150 feet of climbing of which most is attacked at...

Cycling

Events

Press Releases

September 22, 2021

Honey Stinger Launches NIL Program to Support Collegiate Athletes

STEAMBOAT SPRINGS, Colo. (Sept 22, 2021) /ENDURANCE SPORTSWIRE/-- Honey Stinger is pleased to introduce its Hive College Ambassador Program, supporting student-athletes across the country in compliance with the NCAA’s recently updated name, image, and likeness (NIL) policies. The program will be accessible to student-athletes from any college or university through...

Press Releases

Sponsorship

September 22, 2021

Run Show USA, Boston Partners with Boston Athletic Association

/ENDURANCE SPORTSWIRE/-- Run Show USA, Boston the inaugural consumer running exposition scheduled Jan. 29-30, 2022, at Boston’s Hynes Convention Center, today announced that the Boston Athletic Association (B.A.A.), a non-profit organization with a mission of promoting a healthy lifestyle through sports, especially running, will be a key partner for the...

Press Releases

Running

Trade Shows

September 22, 2021

Tour de TOHOKU 2021 goes Virtual on ROUVY

September 22, 2021 /ENDURANCE SPORTSWIRE/-- Tour de TOHOKU is a bicycle event held every year by the Yahoo Japan Corporation, a leading Internet company in Japan and the Kahoku Shimpo Publishing Co., since 2013, for the purpose of supporting the restoration efforts and bequeathing memories, post the Great East Japan...

Cycling

Events

Press Releases

September 22, 2021

Santa Barbara Half Marathon Unveils New Half Marathon and SB Independent 5K courses Featuring a State Street Finish

SANTA BARBARA, Calif. – (September 22, 2021) /ENDURANCE SPORTSWIRE/ -- The Santa Barbara Half Marathon and SB Independent 5K has unveiled the course maps, presented by Village Properties, that will take runners and walkers on a unique journey through downtown Santa Barbara beginning on Cabrillo Blvd. and finishing on State...

Events

Press Releases

Running

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