查回复表中 回复最多的Id

SELECT max( cc.数量 ) , content_id
FROM (

SELECT count ( id ) AS 数量 , content_id
FROM `reply`
GROUP BY content_id

)cc

查回复表中 回复最多的Id倒序排列   (没有回复的id不显示)

SELECT content_id
FROM (

SELECT count ( id ) AS 数量 , content_id
FROM `reply`
GROUP BY content_id

) cc
ORDER BY cc . 数量 DESC

查回复表中 回复最多的Id倒序排列   (所有回复的id都显示)

SELECT content.id
FROM content
LEFT JOIN (

SELECT count( id ) AS 数量, content_id
FROM `reply`
GROUP BY content_id
)cc ON ( cc.content_id = content.id )
ORDER BY cc.数量 DESC