Er zijn geen producten gevonden die aan je selectie voldoen.
WordPress databasefout: [Not unique table/alias: 'e8nEu_term_relationships']SELECT SQL_CALC_FOUND_ROWS e8nEu_posts.ID
FROM e8nEu_posts LEFT JOIN e8nEu_term_relationships ON (e8nEu_posts.ID = e8nEu_term_relationships.object_id) LEFT JOIN e8nEu_icl_translations wpml_translations
ON e8nEu_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', e8nEu_posts.post_type) LEFT JOIN e8nEu_term_relationships ON (e8nEu_posts.ID = e8nEu_term_relationships.object_id)
WHERE 1=1 AND (
e8nEu_term_relationships.term_taxonomy_id IN (500,492)
) AND ((e8nEu_posts.post_type = 'product' AND (e8nEu_posts.post_status = 'publish' OR e8nEu_posts.post_status = 'wc-pre-order'))) AND ( ( ( wpml_translations.language_code = 'nl' OR (
wpml_translations.language_code = 'en'
AND e8nEu_posts.post_type IN ( 'e-floating-buttons','elementor_library','product','order_status' )
AND ( (
( SELECT COUNT(element_id)
FROM e8nEu_icl_translations
WHERE trid = wpml_translations.trid
AND language_code = 'nl'
) = 0
) OR (
( SELECT COUNT(element_id)
FROM e8nEu_icl_translations t2
JOIN e8nEu_posts p ON p.id = t2.element_id
WHERE t2.trid = wpml_translations.trid
AND t2.language_code = 'nl'
AND (
p.post_status = 'publish' OR p.post_status = 'private' OR
( p.post_type='attachment' AND p.post_status = 'inherit' )
)
) = 0 ) )
) ) AND e8nEu_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','e-floating-buttons','elementor_library','product','product_variation','wpcf7_contact_form','order_status','mc4wp-form' ) ) OR e8nEu_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','e-floating-buttons','elementor_library','product','product_variation','wpcf7_contact_form','order_status','mc4wp-form' ) ) AND ( ( e8nEu_posts.ID IN ( SELECT DISTINCT prlg.post_parent FROM e8nEu_atum_inventories ati
LEFT JOIN e8nEu_posts pr ON ati.product_id = pr.ID
LEFT JOIN e8nEu_icl_translations tr ON pr.ID = tr.element_id AND CONCAT('post_', pr.post_type) = tr.element_type
LEFT JOIN e8nEu_icl_translations trlg ON tr.trid = trlg.trid AND trlg.language_code = 'nl'
LEFT JOIN e8nEu_posts prlg ON trlg.element_id = prlg.ID
LEFT JOIN e8nEu_atum_inventory_meta atim ON ati.ID = atim.inventory_id
LEFT JOIN e8nEu_wc_product_meta_lookup pml ON ati.product_id = pml.product_id
LEFT JOIN e8nEu_atum_product_data apd ON ati.product_id = apd.product_id
WHERE (apd.multi_inventory = 1 OR apd.multi_inventory IS NULL) AND ( pml.stock_status IN ('instock','onbackorder') OR atim.stock_status IN ('instock','onbackorder')) AND pr.post_parent IS NOT NULL AND pr.post_parent > 0 ) OR e8nEu_posts.ID IN ( SELECT DISTINCT prlg.ID FROM e8nEu_atum_inventories ati
LEFT JOIN e8nEu_posts pr ON ati.product_id = pr.ID
LEFT JOIN e8nEu_icl_translations tr ON pr.ID = tr.element_id AND CONCAT('post_', pr.post_type) = tr.element_type
LEFT JOIN e8nEu_icl_translations trlg ON tr.trid = trlg.trid AND trlg.language_code = 'nl'
LEFT JOIN e8nEu_posts prlg ON trlg.element_id = prlg.ID
LEFT JOIN e8nEu_atum_inventory_meta atim ON ati.ID = atim.inventory_id
LEFT JOIN e8nEu_wc_product_meta_lookup pml ON ati.product_id = pml.product_id
LEFT JOIN e8nEu_atum_product_data apd ON ati.product_id = apd.product_id
WHERE (apd.multi_inventory = 1 OR apd.multi_inventory IS NULL) AND ( pml.stock_status IN ('instock','onbackorder') OR atim.stock_status IN ('instock','onbackorder')) )) AND (
e8nEu_term_relationships.term_taxonomy_id IN (13)
AND
e8nEu_posts.ID NOT IN (
SELECT object_id
FROM e8nEu_term_relationships
WHERE term_taxonomy_id IN (7,9)
)
)
OR ( e8nEu_posts.ID IN (
SELECT DISTINCT e8nEu_posts.ID FROM e8nEu_posts
LEFT JOIN e8nEu_atum_product_data apd ON e8nEu_posts.ID = apd.product_id
LEFT JOIN e8nEu_wc_product_meta_lookup pml ON e8nEu_posts.ID = pml.product_id
LEFT JOIN e8nEu_term_relationships ON (e8nEu_posts.ID = e8nEu_term_relationships.object_id)
WHERE apd.multi_inventory = 0 AND pml.stock_status IN ('instock','onbackorder') AND (
e8nEu_term_relationships.term_taxonomy_id IN (13)
AND
e8nEu_posts.ID NOT IN (
SELECT object_id
FROM e8nEu_term_relationships
WHERE term_taxonomy_id IN (7,9)
)
) AND (
e8nEu_term_relationships.term_taxonomy_id IN (2,4)
)
) )
OR (
e8nEu_term_relationships.term_taxonomy_id IN (13)
AND
e8nEu_posts.ID NOT IN (
SELECT object_id
FROM e8nEu_term_relationships
WHERE term_taxonomy_id IN (7,9)
)
AND
e8nEu_posts.ID NOT IN (
SELECT object_id
FROM e8nEu_term_relationships
WHERE term_taxonomy_id IN (2,4)
)
) )
GROUP BY e8nEu_posts.ID
ORDER BY e8nEu_posts.post_date DESC, e8nEu_posts.ID DESC
LIMIT 0, 12