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 (16)
) 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 2000, 10

July 19, 2023

2nd Annual Asheville Bike Fest Grows to Include Expo, Industry Night, Film Fest, and Gran Fondo

(Gettysburg, PA – July 19, 2023) /ENDURANCE SPORTSWIRE/ - The second annual Asheville Bike Fest, presented by Cane Creek, attracted cyclists from all over the nation to Asheville, North Carolina, on July 14-16. Activities included a cycling expo at Rabbit Rabbit in downtown Asheville, industry night, bicycle-themed film festival, and...

Cycling

Events

Press Releases

July 18, 2023

Hendersonville Local Luca Shaw and Anna Newkirk Win 2023 Elite Downhill National Titles at Ride Rock Creek

RIDE ROCK CREEK, N.C. /ENDURANCE SPORTSWIRE/ – The 2023 USA Cycling Gravity Mountain Bike National Championships concluded on Sunday in Zirconia, North Carolina. The final day of competition saw hundreds of athletes vying for the national downhill title across multiple age groups. Athletes from across the country took to the three-quarter...

Cycling

Events

Press Releases

July 17, 2023

Thousands of Runners Beat the Heat in Wine Country

Sonoma, CA /ENDURANCE SPORTSWIRE/ – A cross country and track runner at the University of Portland, Nolan Hosbein credits his mother for steering him toward the sport. Mom has been running road races for years and Nolan literally followed in her footsteps at races. “She’s my biggest supporter,” said Hosbein. And on a...

Events

Press Releases

Running

July 17, 2023

Inaugural PNC Presents Rush to Crush Cancer Raised More than $600,000 for UPMC Hillman Cancer Center

PITTSBURGH, PA (July 17, 2023) /ENDURANCE SPORTSWIRE/ – The inaugural PNC presents Rush to Crush Cancer, held on May 19-20, raised more than $600,000 for cancer research at the UPMC Hillman Cancer Center. During the event, 828 riders from 20 states cycled 16,480 miles while inspiring more than 4,000 charity donations....

Cycling

Events

Giving

Press Releases

July 17, 2023

Kate McLaughlin and Ian Lopez de San Roman Win the Stages Cycling Tahoe Trail 100 MTB on Saturday at Northstar Resort

Leadville, Colo., (July 17, 2022)/ENDURANCE SPORTSWIRE/ – The Leadville Race Series Stages Cycling Tahoe Trail, owned and produced by Life Time (NYSE: LTH), took place this past Saturday at the world-class Northstar Resort. Straddling the borders of Nevada and California, the race brought more than 700 riders to the beautiful Sierra Nevada...

Cycling

Events

Press Releases

July 17, 2023

UltraSwim 33.3 x Precision Fuel & Hydration Partnership

/ENDURANCE SPORTSWIRE/ – We want every UltraSwim 33.3 participant to be a winner and that's why we've teamed up with Precision Fuel & Hydration to provide our participants with the education, tools and products to help them perform at their best. With their guided expertise, you'll be better prepared to nail...

Events

Press Releases

Sponsorship

July 17, 2023

Chargel Prepares to Fuel Up San Francisco Marathon Racers

IRVINE, Calif. (July 17, 2023)/ENDURANCE SPORTSWIRE/ –Chargel, the caffeine-free, pocket-sized and easy-to-consume athletic gel drink, will continue its California summer race sponsorship with its onsite attendance and product sampling at the 2023 San Francisco Marathon on July 21 – 23. The official gel sponsor of the San Francisco Marathon, Chargel will...

Events

Press Releases

Running

Sponsorship

Wire Syndication