Multiple joins and multiple counts

[eluser]Phil Sturgeon[/eluser]
Your sub query approach will work out better. Before you probably had problems as each time you are joining tables together you are saying "all the fields should be returned together". This means that the count will count empty strings all over the place, and give you identical or screwy results.

A sub query for each count is usual best practice.