Shame they appear to have confused how GROUP BY works. They're correct that -<p>SELECT users.*, count(photos.id)
FROM users
LEFT OUTER JOIN photos
  ON users.id = photos.user_id
GROUP BY photos.user_id<p>won't do what they want. In fact, it isn't even a valid query outside of MySQL that I can think of.<p>What -will- do the right thing is:<p>SELECT users.id, users.name, count(photos.id)
FROM users
LEFT OUTER JOIN photos
  ON users.id = photos.user_id
GROUP BY users.id, users.name<p>(which in the conceptually similar perl thing I'm working on at the moment you'd represent just by asking for a set of user objects with $user-&#62;photos-&#62;count eager loaded, but anyway ...)