changed project show joins to left outer joins