postgresql requires venues.id to be in the GROUP BY, for whatever reason.