56,679
社区成员
发帖
与我相关
我的任务
分享
SELECT *
FROM comments
LEFT JOIN ( SELECT parent_id ,
COUNT(1) AS likecount
FROM comments
WHERE news_id = 1
AND like_it = 1
GROUP BY parent_id
) t ON comments.id = t.parent_id
WHERE comment <> ''
AND comment IS NOT NULL
ORDER BY t.likecount DESC ,
comment_time
SELECT *
FROM comments
LEFT JOIN ( SELECT parent_id ,
COUNT(1) AS likecount
FROM comments
WHERE news_id = 1
AND like_it = 1
GROUP BY parent_id
) t ON comments.id = t.parent_id
ORDER BY t.likecount DESC,comment_time
SELECT *
FROM comments
JOIN ( SELECT parent_id ,
COUNT(1) AS likecount
FROM comments
WHERE news_id = 1
AND like_it = 1
GROUP BY parent_id
) t ON comments.id = t.parent_id
ORDER BY t.likecount DESC