brotherhood_of_LAN - 9:13 am on Jul 22, 2010 (gmt 0)

If you post the query you currently have, then I'd be able to add to it as I don't know the table names or what you want to do with the query.

That said, if you try putting the GROUP BY statement after your WHERE statement, it should work fine.