The only thing I don't like about this solution is, it doubles the number of sql queries in the worst case. If your db is already heavily loaded at time of execution, it makes matters worse. If your db is sitting around doing nothing, it works really well.

++sgifford, since it works really well on small inputs regardless. :)