Maybe I'm just unfamiliar with some of the Postgres syntax.. but shouldn't there be a GROUP BY in the first query?