Steps to reproduce

Combine sql left join with a arel join causes wrong order

https://gist.github.com/ryan-plated/cae50e8eceb621f8a76d41f2e6d1b5ec

Expected behavior

should keep order

Actual behavior

goes out of order

System configuration

Rails version: master

Ruby version: 2.5.0