Ilmari Karonen wrote:
Ideally, you'd want to sort them by expiration time, but I suppose this may not be trivial.
It's trivial.
Also, would this be a good time to ensure that usernames in ipb_address are properly normalized? It seems that at the moment, on enwiki at least, some of the entries contain underscores and some spaces, the choice seeming quite random:
http://en.wikipedia.org/wiki/Special:Ipblocklist?ip=+ http://en.wikipedia.org/wiki/Special:Ipblocklist?ip=_
I'll look into that.
-- Tim Starling