WordPress database error: [Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=']
( SELECT 0 AS is_personal, 1 AS is_ip, status, country_code, network, mask FROM wp_xxcdtb_spbc_firewall_data_v4 WHERE network IN (310378496,314572800,315621376,316145664,316178432,316186624,316190720,316192768,316193792,316194304,316194432,316194464,316194468,316194470,316194471) AND network = 316194471 & mask AND country_code = "0" ) UNION ( SELECT 1 AS is_personal, 1 AS is_ip, status, 0 AS country_code, network, mask FROM wp_xxcdtb_spbc_firewall__personal_ips_v4 WHERE network IN (310378496,314572800,315621376,316145664,316178432,316186624,316190720,316192768,316193792,316194304,316194432,316194464,316194468,316194470,316194471) AND network = 316194471 & mask ) UNION ( SELECT 1 AS is_personal, 0 AS is_ip, tbl_private.status, country_code, network, mask FROM wp_xxcdtb_spbc_firewall__personal_countries AS tbl_private RIGHT JOIN wp_xxcdtb_spbc_firewall_data_v4 AS tbl_common USING(country_code) WHERE network IN (310378496,314572800,315621376,316145664,316178432,316186624,316190720,316192768,316193792,316194304,316194432,316194464,316194468,316194470,316194471) AND network = 316194471 & mask AND tbl_private.status IS NOT NULL AND 40099 <> 0 )