SELECT comment_post_ID, count( * ) AS fc
FROM evo_comments
GROUP BY comment_post_id
order by fc desc