Converted joins to left joins on the sfari query.