fix wrong(deprecated) join syntax