Leggendo e adatando quanto spiegato qui https://webmasters.stackexchange.com/questions/9194/mass-deletion-of-spam-revisions-in-mediawiki , eseguire
USE wikitrek; DELETE QUICK FROM wiki_user WHERE user_id<>3 AND user_id<>2 AND user_id<>5 AND user_id<>7 AND user_id<>9 AND user_id<>11 AND user_id<>14 AND user_id<>463 AND user_id<>554 AND user_id<>461 AND user_id<>6 AND user_id<>464 AND user_id<>1 AND user_id<>496 AND user_id<>12 AND user_id<>1529; DELETE FROM wiki_user_groups WHERE ug_user NOT IN (SELECT user_id FROM wiki_user); DELETE FROM wiki_user_properties WHERE up_user NOT IN (SELECT user_id FROM wiki_user); DELETE FROM wiki_user_newtalk WHERE user_id NOT IN (SELECT user_id FROM wiki_user); DELETE FROM wiki_revision WHERE rev_actor > 0 AND rev_actor NOT IN (SELECT user_id FROM wiki_user);