WordPress database error: [Unknown column 'posts.ID' in 'IN/ALL/ANY subquery']
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND ( wp_posts.ID NOT IN ( SELECT object_id FROM wp_term_relationships WHERE term_taxonomy_id IN (8) ) AND wp_term_relationships.term_taxonomy_id IN (79) ) AND ((wp_posts.post_type = 'product' AND (wp_posts.post_status = 'publish'))) AND posts.ID IN ( SELECT tr.object_id FROM wp_term_relationships AS tr WHERE tr.term_taxonomy_id IN (81) ) AND (EXISTS ( SELECT 1 FROM wp_term_relationships tr INNER JOIN wp_term_taxonomy tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tr.object_id = wp_posts.ID AND tt.taxonomy = 'brand' AND tt.term_id IN (81) )) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order ASC, wp_posts.post_title ASC LIMIT 0, 12