Andere pakketten

Geen producten gevonden die aan je zoekcriteria voldoen.

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_wc_product_meta_lookup wc_product_meta_lookup ON wp_posts.ID = wc_product_meta_lookup.product_id INNER JOIN wp_postmeta istockstatus ON (wp_posts.ID = istockstatus.post_id) WHERE 1=1 AND istockstatus.meta_key = '_stock_status' AND istockstatus.meta_value <> '' AND ( wp_posts.ID NOT IN ( SELECT object_id FROM wp_term_relationships WHERE term_taxonomy_id IN (9) ) AND wp_term_relationships.term_taxonomy_id IN (21) ) AND wp_posts.post_type = 'product' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled') GROUP BY wp_posts.ID ORDER BY istockstatus.meta_value ASC, wc_product_meta_lookup.min_price ASC, wc_product_meta_lookup.product_id ASC LIMIT 0, 16