WordPress database error: [Illegal mix of collations (utf8mb4_unicode_520_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '=']
(
SELECT 0 AS is_personal, 1 AS is_ip, status, country_code, network, mask
FROM wpaw_spbc_firewall_data_v4
WHERE network IN (2415919104,2432696320,2433220608,2433482752,2433613824,2433646592,2433650688,2433652736,2433653760,2433654272,2433654528,2433654530,2433654531)
AND network = 2433654531 & mask
AND country_code = "0"
) UNION (
SELECT 1 AS is_personal, 1 AS is_ip, status, 0 AS country_code, network, mask
FROM wpaw_spbc_firewall__personal_ips_v4
WHERE network IN (2415919104,2432696320,2433220608,2433482752,2433613824,2433646592,2433650688,2433652736,2433653760,2433654272,2433654528,2433654530,2433654531)
AND network = 2433654531 & mask
) UNION (
SELECT 1 AS is_personal, 0 AS is_ip, tbl_private.status, country_code, network, mask
FROM wpaw_spbc_firewall__personal_countries AS tbl_private
RIGHT JOIN wpaw_spbc_firewall_data_v4 AS tbl_common USING(country_code)
WHERE network IN (2415919104,2432696320,2433220608,2433482752,2433613824,2433646592,2433650688,2433652736,2433653760,2433654272,2433654528,2433654530,2433654531)
AND network = 2433654531 & mask
AND tbl_private.status IS NOT NULL
AND 29032 <> 0
)
