fixed outer_joins usage