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 (50331648,50855936,51118080,51249152,51281920,51298304,51306496,51310592,51312640,51313664,51313920,51314048,51314112,51314128,51314136,51314140,51314141)
AND network = 51314141 & 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 (50331648,50855936,51118080,51249152,51281920,51298304,51306496,51310592,51312640,51313664,51313920,51314048,51314112,51314128,51314136,51314140,51314141)
AND network = 51314141 & 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 (50331648,50855936,51118080,51249152,51281920,51298304,51306496,51310592,51312640,51313664,51313920,51314048,51314112,51314128,51314136,51314140,51314141)
AND network = 51314141 & mask
AND tbl_private.status IS NOT NULL
AND 77556 <> 0
)