When using order by in a query that uses the same table multiple times, the order could be incorrect.