I have found a ton more spam users in my database. They are all with the email ending @sina.com, so other people here might want to check their databases. Anyway there are over 200 of these things, all have zero points and have done nothing on the site. (I am about to block that email from registering.)
I want to quickly delete them all but finding each username, opening the link on the site, and deleting them there will take FOREVER. So I want to know, which tables need the accounts deleted from? And is there an order I need to do things in?
Assume that I have a list of IDs so I can run queries like:
DELETE FROM qa_users WHERE userid IN (12345, 12346, 12347, ...)