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

September 25, 2020

Seirus Innovation Launches HeiQ Tech in the Face of COVID-19

SAN DIEGO, CA (September 25, 2020) -- Seirus Innovation, a family-owned company focused on keeping extremities comfortable with over 20 patents since 1984, announces the introduction of the Swiss technology HeiQ V-Block into over 20 products starting this Fall in multiple lines including the highly anticipated EVO Arc Masque ™,...

Press Releases

Products

September 25, 2020

Alta Cycling Group Rolls Out New Beeline Connect Bridge Software

KENT, Wash., (September 25, 2020) — Alta Cycling Group, a premier cycling company, is incorporating Beeline Connect’s new Bridge software to facilitate a new dealer locators integrated on Diamondback, Redline, IZIP, Haibike and Raleigh websites, to provide added support and improve processes for their authorized dealer network. This added software...

Business

Cycling

Press Releases

September 25, 2020

Ski & Snowboard Club Vail and SWIX Sport USA Launch Two Year Strategic Partnership

With the recent adoption of rules by F.I.S. and US Ski & Snowboard banning the use of fluoro waxes effective immediately this season, Ski & Snowboard Club Vail (SSCV) is thrilled to announce a two year strategic partnership arrangement with SWIX Sport USA (SWIX) in support of all of its...

Press Releases

Sponsorship