remove all AS from the left joins