ORDER BY the inner query so the order is deterministic + It uses the INDEX