Essentials

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