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

November 18, 2021

Revelshine Sustainable Wines Partners With New WineShine Half Marathon

NAPA, Calif. /ENDURANCE SPORTSWIRE/ - The WineShine Half Marathon is thrilled to welcome Revelshine as the sustainable-premium-wine partner for its 2022 inaugural event. Revelshine, a premium, world-class wine in a sustainable, portable and recyclable aluminum bottle, will provide a bottle of wine to each half-marathon participant in the July 16, 2022...

Press Releases

Running

Sponsorship

November 18, 2021

Bearclaw Bicycle Co. Named ‘Ultra Series’ Sponsor for 2022 Michigan Gravel Race Series

/ENDURANCE SPORTSWIRE/ -As part of the upcoming 2022 Michigan Gravel Race Series (MGRS), Bearclaw Bicycle Co. has renewed its sponsorship for the second year running as the official Ultra Series sponsor. The Bearclaw Bicycle Co. Ultra Series includes seven 100+ mile gravel bike races among the 15 events within the...

Cycling

Events

Press Releases

Sponsorship

November 18, 2021

Brent Bookwalter joins the Pro Cyclist Foundation

Denver, Colorado, November 18, 2021 /ENDURANCE SPORTSWIRE/ - The Pro Cyclist Foundation has named Brent Bookwalter as a Vice Chairman for the Foundation's Board of Directors. Bookwalter will also be providing consulting and advisory work for the Foundation's Athlete Services Committee. Bookwalter recently retired from a 16-year career as a...

Business

Cycling

Press Releases

November 17, 2021

ELITE & Zwift Partner up for Midweek Mountain Massif TT

FONTANIVA, ITALY, November 17th, 2021 /ENDURANCE SPORTSWIRE/ - Elite Cycling and Zwift Insider are teaming up for two Thanksgiving Eve throw-downs in the mountains and you're invited. Midweek Mountain Massif TT What do you get if you cross a mountain race and a time trial? An absolutely intense, but highly...

Cycling

Events

Press Releases

November 17, 2021

Enduro MTB Training Announces Train to Ride: Performance and strength training for cycling and moto

/ENDURANCE SPORTSWIRE/ - Enduro MTB Training founder and long-time coach, racer, and trainer, Dee Tidwell, announces the expansion of his performance and strength training programs beyond the MTB discipline with Train to Ride, changing the way cyclists approach strength training. Train to Ride is now offering cycling-specific programs and plans for...

Business

Cycling

Press Releases

November 17, 2021

Showcased

rabbit Partners with Women-Led Wednesday to Empower Women Leaders

November 17th, 2021. Santa Barbara, California /ENDURANCE SPORTSWIRE/ - California-based running apparel company, rabbit, has partnered with Women-Led Wednesday to support and promote women in leadership. Founded by two women, Monica DeVreese and Jill Deering, with decades of experience in the running industry, rabbit has long championed gender equality and a...

Business

Press Releases

Running

November 17, 2021

VKTRY Brings NFL Star Jonathan Taylor On Board As Latest Brand Ambassador

November 17, 2021 - Milford, Conn. /ENDURANCE SPORTSWIRE/ - VKTRY GEAR, the fast growing, industry leader in Performance Insoles for heightened athletic performance and injury protection, continued to make 2021 a record year, announcing six months in a row of month over month sales increases while bringing fast-rising NFL running...

Press Releases

Products

Sponsorship

November 17, 2021

USA Cycling To Partner With THRU To Ship Member Bikes Across The US

November 17, 2021 (COLORADO SPRINGS, CO)  /ENDURANCE SPORTSWIRE/ -  USA Cycling announces today their partnership with THRU as their Official Bike Transport Sponsor. Members will be able to take advantage of the full range of shipping and destination concierge services starting with the USA Cycling Cyclocross National Championships on December...

Business

Cycling

Press Releases

Triathlon