MIN KONTO
ØNSKELISTE
SAMMENLIGN
FØLG DIN ORDRE
Viser 1 resultat
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 = 18224 ) OR ( type = 'category' AND object IN ('2811', '2818', '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 = 18224 ) 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 ('2811', '2818', '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
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 = 18224 ) OR ( type = 'category' AND object IN ('2811', '2818', '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 = 18224 ) 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 ('2811', '2818', '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