fixed problem with the nested leftjoin, still red junit