56,912
社区成员




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