It would be nice to cleanup Wikimini users from the database wikimini_stockwiki. Now the registered users are 1+ million. Most of them are just probably automated accounts with bad intentions.

A mitigation for this situation is proposed here:

• T331103: Prevent Wikimini spammers to register via email, and just allow registration using OAuth

These two activities are complementary and can be started in any order.

To begin with, it would be useful to:

• see some already existing utilities
• find some criteria for identifying spammers in wikimini_stockwiki
  • maybe users without edits and without a confirmed email?
    • SELECT COUNT(*) FROM user WHERE user_editcount = 0 AND user_email_authenticated IS NULL → 285469
  • maybe other things?