Really? Given that the outer `SELECT` has no `ORDER BY`, I don't see why. That's why I had the `ORDER BY` *outside* of the CTE, and not *inside* like you do, in [my earlier post](https://sqlite.org/forum/forumpost/c809e7e3e1)
Really? Given that the outer `SELECT` has no `ORDER BY`, I don't see why. That's why I had the `ORDER BY` *outside* of the CTE, and not *inside* like you do, in [my earlier post](https://sqlite.org/forum/forumpost/c809e7e3e1)