But the trouble is: there is a possibility that each "faceted item" may have multiple records for a given facet. That's not supposed to be the case, but there are errors in the database that I'm trying to clean up.

So, what I'd like to be able to do is grab the record for each faceted item with the highest id value (logically, the most recent.)