Changed leftJoin(...) to join('LEFT', ...)