leftJoin, nested tuples added. A hack for group by removed.