join query and lost commit to db are added