Array ( [where] => AND ( wp_posts.ID NOT IN ( SELECT object_id FROM wp_term_relationships WHERE term_taxonomy_id IN (7) ) AND wp_term_relationships.term_taxonomy_id IN (2259) ) AND ( wp_postmeta.meta_key = '_stock_status' AND ( ( mt1.meta_key = '_stock_status' AND mt1.meta_value IN ('instock','onbackorder') ) OR ( mt1.meta_key = '_stock_status' AND mt1.meta_value = 'outofstock' ) ) ) AND ((wp_posts.post_type = 'product' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled' OR wp_posts.post_status = 'cwg_mailsent' OR wp_posts.post_status = 'cwg_mailnotsent' OR wp_posts.post_status = 'cwg_subscribed' OR wp_posts.post_status = 'cwg_unsubscribed' OR wp_posts.post_status = 'cwg_converted' OR wp_posts.post_status = 'wc-boxnow-canceled'))) [groupby] => wp_posts.ID [join] => LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) [orderby] => CASE WHEN (SELECT meta_value FROM wp_postmeta WHERE post_id = wp_posts.ID AND meta_key = '_stock_status') = 'instock' AND EXISTS (SELECT 1 FROM wp_term_relationships tr JOIN wp_term_taxonomy tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tr.object_id = wp_posts.ID AND tt.taxonomy = 'nakladnici' AND tt.term_id = 0) THEN 1 WHEN (SELECT meta_value FROM wp_postmeta WHERE post_id = wp_posts.ID AND meta_key = '_stock_status') = 'instock' THEN 2 WHEN (SELECT meta_value FROM wp_postmeta WHERE post_id = wp_posts.ID AND meta_key = '_stock_status') = 'outofstock' AND EXISTS (SELECT 1 FROM wp_term_relationships tr JOIN wp_term_taxonomy tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tr.object_id = wp_posts.ID AND tt.taxonomy = 'nakladnici' AND tt.term_id = 0) THEN 3 ELSE 4 END ASC, wp_posts.post_date ASC [distinct] => [fields] => wp_posts.* [limits] => LIMIT 0, 20 )