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 (143,191,192,193,194,195,196,198,199,200,201,202,209,210,197,203,204,205) AND tt1.term_taxonomy_id IN (191,192,193,194,195,196,209,210) AND tt2.term_taxonomy_id IN (192) ) 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] => spirits [field] => slug [operator] => IN ) [1] => Array ( [taxonomy] => product_cat [terms] => tequila-mezcal [field] => slug [operator] => IN ) [2] => Array ( [taxonomy] => product_cat [terms] => blanco [field] => slug [operator] => IN ) ) ) 26
Showing all 26 results
