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_rt', 'A_alejandro', 'C_????') GROUP BY label ) as freqs WHERE target.post_id NOT IN ('358') AND target.label=freqs.label AND target.label IN ('A_rt', 'A_alejandro', 'C_????') 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;