In order to find out which blog entries of mine have the most comments so far, this is the SQL query that can be used:
SELECT mt_comment.comment_entry_id, COUNT(*) AS cnt FROM mt_comment WHERE mt_comment.comment_visible=1 GROUP BY mt_comment.comment_entry_id ORDER BY cnt DESC LIMIT 25;
As you can see over there on the righthand margin under the 'Most comments' section, I have enumerated the top twenty five.
Have a look and tell me what you think.
Turns out that I left something important out, namely that all my comments must first be approved by me before they become visible. Therefore, the query should include where comment_visible is true (added).