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

September 28, 2020

OluKai Launches Premium Shearling, Leather, and Wool Slippers

Irvine, CA – Sept. 28, 2020– OluKai, the premium Hawaiian-inspired lifestyle brand, is thrilled to introduce several new slipper styles for men and women. According to Google Trends, 2020 research searches for slippers have already doubled over the 5-year trend. Known for comfort, OluKai is taking the aloha spirit one...

Press Releases

Products

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