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) LEFT JOIN wp_term_relationships AS tt1 ON (wp_posts.ID = tt1.object_id) LEFT JOIN wp_term_relationships AS tt2 ON (wp_posts.ID = tt2.object_id) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (285) AND tt1.term_taxonomy_id IN (125,127,128,129,130,131,150,151,152,153,154) AND tt2.term_taxonomy_id IN (153) ) AND wp_posts.post_type = 'product' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_title ASC LIMIT 0, 45 Array ( [post_type] => product [post_status] => publish [posts_per_page] => 45 [orderby] => title [order] => ASC [suppress_filters] => 1 [tax_query] => Array ( [relation] => AND [0] => Array ( [taxonomy] => product_cat [terms] => wine [field] => slug [operator] => IN ) [1] => Array ( [taxonomy] => grapes [terms] => red-wine [field] => slug [operator] => IN ) [2] => Array ( [taxonomy] => grapes [terms] => sangiovese [field] => slug [operator] => IN ) ) ) 8
Showing all 8 results
