mistakenly changed a join statement