>Let's say I have an ordered list of ids that correspond to an ordered
There's no ordering in an IN clause to preserve. If you don't ORDER BY,
you have no complaint about the order you get.
Create a table ordering with columns consisting of the ids and the
Join the table against the table with the
records. ORDER BY ordering.ordering desc .
This may not be most efficient, but it shouldn't be too bad.