mediawiki sidebar

I end up editing this often, but there is no convenient link, so for future reference MediaWiki:Sidebar

mediawiki spam

well, there was a bunch of media wiki spam.  I attempted to get rid of it with
update revision left outer join user on `rev_user` = `user_id` set revision.rev_deleted = 1 where user_id is NULL and rev_page > 1

after I deleted the bogus users.  I did a backup before hand just in case I got a query wrong.

It seems to have mostly worked.