Protected: 对贞薰嗣的一点感想什么的
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 ('P_???????wwww', 'P_?????')
GROUP BY label
) as freqs
WHERE
target.post_id NOT IN ('808') AND
target.label=freqs.label AND
target.label IN ('P_???????wwww', 'P_?????') 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;
