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 = 26272 ) OR ( type = 'category' AND object IN ('2628', '2623', '2618', '2617', '2622', '2627', '2603', '2608', '2607', '2598', '2593', '2592', '2597', '2602', '2583', '2588', '2587', '2579', '2575', '2574', '2578', '2582', '3246', '3255', '3303', '3313', '3315', '3305', '3247', '2572', '2571', '2570', '2569') )
)
)
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 = 26272
)
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 ('2628', '2623', '2618', '2617', '2622', '2627', '2603', '2608', '2607', '2598', '2593', '2592', '2597', '2602', '2583', '2588', '2587', '2579', '2575', '2574', '2578', '2582', '3246', '3255', '3303', '3313', '3315', '3305', '3247', '2572', '2571', '2570', '2569')
)
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
