bugfix of conditions of multiple join.