SELECT users.name, fotos.name FROM users
   LEFT JOIN photos ON
      fotos.id = (SELECT MAX(id) FROM fotos WHERE userid = users.id)
ORDER BY users.datum DESC
LIMIT 3,40