Extenstion of blog tutorial -> Counting the Comments

[eluser]deviant[/eluser]
The SQL query I was using for counting comments on news items was something along the lines of

Code:

SELECT news.*, COUNT(comment.id) AS num_comments FROM news LEFT JOIN comment ON (comment.post_id=news.id) GROUP BY news.id ORDER BY news.date_posted DESC