ilovinheart

WordPress database error: [Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_unicode_520_ci,COERCIBLE) for operation '=']
SELECT target.post_id, sum(target.weight * log(48 / least(48, freqs.freq))) as score FROM wp_wp_rp_tags as target, (SELECT label, count(1) as freq FROM wp_wp_rp_tags WHERE label IN ('A_figur', 'A_back', 'A_xp', 'A_hr', 'A_div', 'C_wordpress', 'A_im') GROUP BY label ) as freqs WHERE target.post_id NOT IN ('868') AND target.label=freqs.label AND target.label IN ('A_figur', 'A_back', 'A_xp', 'A_hr', 'A_div', 'C_wordpress', 'A_im') AND target.post_id NOT IN ( SELECT post_id FROM wp_wp_rp_tags WHERE label IN ('C_黑历史') ) GROUP BY target.post_id ORDER BY score desc, target.post_id desc LIMIT 10;