You could do better with the joins, imho less readable than the equivalent in sql.