Profilling my application help

[eluser]kaejiavo[/eluser]
Hi,
of course it can be done another way, like

Code:

SELECT *, (SELECT COUNT(*) FROM `comments` WHERE ...) as commentCount FROM posts ...

this depends on your database structure, just for you to get the idea.

Marco