mySQL query help

[eluser]dmorin[/eluser]
It's probably going to be easiest for you to use separate queries rather than trying to do everything in one. The problem is that you're doing multiple joins combined with aggregate functions which will almost certainly through off your aggregated counts and sums.

Do the first query to get all of the rows you want from twibsDB, make an array of all the ids you want, and then use where_in() to query each other table, grouping on the twibsID column.