Multiple joins and multiple counts

[eluser]Daniel H[/eluser]
...now I'm using two subqueries to get the counts... not sure if that is good practice?!

Code:

SELECT posts.id, posts.title,

    (SELECT COUNT(c.id) AS c_count FROM posts AS p LEFT JOIN post_comment AS pc ON p.id = pc.post_id INNER JOIN comments AS c ON pc.comment_id = c.id WHERE p.id = posts.id) AS comment_count

FROM posts

ORDER BY posts.id DESC