WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') GROUP BY terms.term_id' at line 15]
SELECT COUNT( DISTINCT wpev_posts.ID ) as term_count, terms.term_id as term_count_id FROM wpev_posts INNER JOIN wpev_term_relationships AS term_relationships ON wpev_posts.ID = term_relationships.object_id INNER JOIN wpev_term_taxonomy AS term_taxonomy USING( term_taxonomy_id ) INNER JOIN wpev_terms AS terms USING( term_id ) LEFT JOIN wpev_term_relationships ON (wpev_posts.ID = wpev_term_relationships.object_id) WHERE wpev_posts.post_type IN ( 'product' ) AND wpev_posts.post_status = 'publish' AND ( wpev_posts.ID NOT IN ( SELECT object_id FROM wpev_term_relationships WHERE term_taxonomy_id IN (7) ) AND wpev_term_relationships.term_taxonomy_id IN (47) )AND terms.term_id IN () GROUP BY terms.term_id