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 = 22597 ) OR ( type = 'category' AND object IN ('141') )
)
)
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 = 22597
)
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 ('141')
)
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
Ikke kategoriseret