rollback inner join changes, left joins actually enforce order