[tmandry]

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

[hglaser]

Thanks! Fixed.