Ok, I think I will have to order on the client then.

Thanks GilaMonster 🙂

GilaMonster (11/16/2016)

---

You need an ORDER BY on the outer query. Without said ORDER BY, the optimiser is free to choose plans that return the data in any order at all,...