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

August 26, 2020

SBT GRVL Raises $30K for Advocacy Partners Through SBT VRTL Ride Experience

STEAMBOAT SPRINGS, Colo., (August 26, 2020) –SBT GRVL, a world-class gravel bike experience presented by Canyon Bicycles, raised $30,000 dollars for its advocacy partners through its global virtual ride, SBT VRTL . This free community ride experience was held on Sunday, August 16. Leading up to SBT VRTL the SBT GRVL...

Business

Cycling

Giving

Press Releases

August 25, 2020

Tread Labs Partners with Press Forward as PR and Communications Agency

WOBURN, Mass. (August 25, 2020)-- Performance insole developer Tread Labs is happy to announce it has entered a partnership with Press Forward PR to further the company’s messaging, communications, and media relations. Tread Labs was founded in 2015 by Mark Paigen, who also founded, and has since sold, Chaco sandals...

Business

Press Releases