MariaDB社区

标题: 如何高效返回每个infomation中info_comment得票数最多的commentContent [打印本页]

作者: yongpiao 时间: 2010-2-21 21:21
标题: 如何高效返回每个infomation中info_comment得票数最多的commentContent
infomation信息表字段 infoID
info_comment信息评论表字段 commentID，infoID,commentContent
comment_vote 用户投票表字段 commentID，infoID，voterID
如何高效返回每个infomation中info_comment得票数最多的commentContent？怎么用上索引？

作者: yongpiao 时间: 2010-2-21 21:26
我自己写的方法，感觉很不好：
select * from info_comment d,
(SELECT *
FROM (

SELECT *
FROM (

SELECT infoID, commentID, count( commentID ) AS commentCount
FROM `comment_vote`
GROUP BY infoID, commentID
) AS a
ORDER BY infoID, commentCount DESC
) AS b
GROUP BY infoID) as c
where d.infoID=c.infoID and d.commentID=c.commentID

欢迎光临 MariaDB社区 (http://123.56.88.72/)