Mutiple SQL count() from several tables

[eluser]agartzia[/eluser]
Hi! I'm trying to get some data from my database (MySQL) and I've been wandernig without any clear solution. Here's the problem:

I want to extract some data from my users (SELECT name, address, mail) and some statistics about them. I would like to get the count() on their Private Messages, Posts and Logged times.

I'm trying something like this

Code:

SELECT name,
       address,
       mail,
      (SELECT count(*) FROM pm WHERE user = "102") as total_pm,
      (SELECT count(*) FROM posts WHERE user = "102") AS total_posts,
      (SELECT count(*) FROM login WHERE user = "102") as total_login
FROM users
WHERE id = "102"
LIMIT 1

Of course it isn't working at all.

There's a way to make it without making 3-extra queries for each user?

Thanks!