SELECT max( cc.数量 ) , content_id
FROM (
SELECT count ( id ) AS 数量 , content_id
FROM `reply`
GROUP BY content_id )cc
FROM (
SELECT count ( id ) AS 数量 , content_id
FROM `reply`
GROUP BY content_id
查回复表中 回复最多的Id倒序排列 (没有回复的id不显示)
SELECT
content_id
FROM (
SELECT count ( id ) AS 数量 , content_id
FROM `reply`
GROUP BY content_id
)
cc
ORDER BY cc . 数量 DESC
FROM (
SELECT count ( id ) AS 数量 , content_id
FROM `reply`
GROUP BY content_id
ORDER BY cc . 数量 DESC
查回复表中 回复最多的Id倒序排列 (所有回复的id都显示)
SELECT content.id
FROM content
LEFT JOIN (
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
FROM `reply`
GROUP BY content_id
)cc ON ( cc.content_id = content.id )
ORDER BY cc.数量 DESC