Note: this isint related to my other thread.<BR><BR>Hey<BR><BR>Im writing a php app to collect statistics about our platform. I have about 40 different count(*) querys to run against a mysql database.

I have a SQL query problem and you guys haven't failed me yet, so hopefully, this one will be a piece of cake. I'm trying to write a query to return a category and 2 counts per category based on ...