WordPress databasefejl: [Table 'i13367_01.i123cms_yith_wapo_blocks_assoc' doesn't exist]
SELECT blocks.id
FROM i123cms_yith_wapo_blocks as blocks
WHERE
(
visibility IN ('1')
)
AND
(
id IN (
SELECT id FROM i123cms_yith_wapo_blocks
WHERE vendor_id IN ('0')
)
)
AND
(
(
id IN (
SELECT id FROM i123cms_yith_wapo_blocks
WHERE product_association = 'all'
)
OR
id IN (
SELECT DISTINCT(id) FROM i123cms_yith_wapo_blocks as i1
JOIN i123cms_yith_wapo_blocks_assoc as a1 on a1.rule_id = i1.id
WHERE product_association = 'products'
AND ( type = 'product' AND object = 10136 ) OR ( type = 'category' AND object IN ('2707', '2702', '2697', '2687', '2692', '2677', '2682', '2662', '2667', '2652', '2657', '2612', '2672', '2571', '3499', '3480', '2806') )
)
)
AND
(
id IN (
SELECT id FROM i123cms_yith_wapo_blocks
WHERE user_association IN ( 'all', 'guest_users' )
)
OR
id IN (
SELECT DISTINCT(id) FROM i123cms_yith_wapo_blocks as i2
JOIN i123cms_yith_wapo_blocks_assoc as a2 on a2.rule_id = i2.id
WHERE user_association = 'user_roles'
AND ( type = 'user_role' AND object IN ('0') )
)
OR
id IN (
SELECT DISTINCT(id) FROM i123cms_yith_wapo_blocks as i3
JOIN i123cms_yith_wapo_blocks_assoc as a3 on a3.rule_id = i3.id
WHERE user_association = 'membership'
AND ( type = 'membership' AND object IN ('0') )
)
)
)
AND
(
id NOT IN (
SELECT DISTINCT(rule_id)
FROM i123cms_yith_wapo_blocks as i4
JOIN i123cms_yith_wapo_blocks_assoc as a4 on a4.rule_id = i4.id
WHERE exclude_products = 1 AND type = 'excluded_product' AND object = 10136
)
AND
id NOT IN (
SELECT DISTINCT(rule_id)
FROM i123cms_yith_wapo_blocks as i5
JOIN i123cms_yith_wapo_blocks_assoc as a5 on a5.rule_id = i5.id
WHERE exclude_products = 1 AND type = 'excluded_category' AND object IN ('2707', '2702', '2697', '2687', '2692', '2677', '2682', '2662', '2667', '2652', '2657', '2612', '2672', '2571', '3499', '3480', '2806')
)
AND
id NOT IN (
SELECT DISTINCT(rule_id)
FROM i123cms_yith_wapo_blocks as i6
JOIN i123cms_yith_wapo_blocks_assoc as a6 on a6.rule_id = i6.id
WHERE exclude_users = 1 AND type = 'excluded_user_role' AND object IN ('0')
)
)
ORDER BY priority,id
