WordPress database error: [Illegal mix of collations for operation ' IN ']
SELECT target.post_id, sum(target.weight * log(19219 / least(19219, freqs.freq))) as score FROM ew_wp_rp_tags as target, (SELECT label, count(1) as freq FROM ew_wp_rp_tags WHERE label IN ('A_figur', 'A_86', 'A_67', 'A_43', 'A_27', 'A_93', 'A_22', 'A_4', 'A_2', 'A_12', 'A_alt', 'A_br', 'A_24', 'C_????', 'C_????? ?????', 'P_????????', 'P_????') GROUP BY label ) as freqs WHERE target.post_id NOT IN ('39804') AND target.label=freqs.label AND target.label IN ('A_figur', 'A_86', 'A_67', 'A_43', 'A_27', 'A_93', 'A_22', 'A_4', 'A_2', 'A_12', 'A_alt', 'A_br', 'A_24', 'C_????', 'C_????? ?????', 'P_????????', 'P_????') AND target.post_id NOT IN ( SELECT post_id FROM ew_wp_rp_tags WHERE label IN ('C_اجتماع', 'C_اسلایدشو', 'C_افغانستان', 'C_تحلیل', 'C_جهان', 'C_سیاست', 'C_عکس خبری', 'C_گزارش', 'C_منطقه') ) GROUP BY target.post_id ORDER BY score desc, target.post_id desc LIMIT 12;