加一个表 表tb_focus logid 记录ID userid 用户ID artid 文章ID选出语句:SELECT m.artid, COUNT(m.userid) AS hot FROM tb_focus m LEFT JOIN tb_focus s ON m.userid=s.userid WHERE s.userid IN ( SELECT userid FROM tb_focus WHERE artid = '$artid' ORDER BY logid DESC LIMIT 10 ) GROUP BY m.userid ORDER BY hot DESC LIMIT 10 试试。
logid 记录ID
userid 用户ID
artid 文章ID选出语句:SELECT m.artid,
COUNT(m.userid) AS hot
FROM tb_focus m
LEFT JOIN tb_focus s ON m.userid=s.userid
WHERE s.userid IN (
SELECT userid
FROM tb_focus
WHERE artid = '$artid'
ORDER BY logid DESC
LIMIT 10
)
GROUP BY m.userid
ORDER BY hot DESC
LIMIT 10
试试。