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

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

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

November 17, 2021

BibRave Names Julia Montag VP of Strategic Accounts

Portland, OR /ENDURANCE SPORTSWIRE/ - BibRave, the leading-edge endurance and fitness marketing agency, recently promoted Julia Montag from Director of Strategic Accounts to VP of Strategic Accounts. Montag first joined Team BibRave in 2014 as a volunteer when the organization was still a start-up. Julia’s unparalleled level of client service...

Business

Press Releases

Running