🇳🇱
@khird Excellent job this week getting rid of spam accounts that had never posted. Lot of time you invested, very much appreciated.
@freemo Happy to help & earn my keep as a mod.
Do you know if there's a way to run more complex queries than simple searches? For example, if I could get the set of local users who have a link in their bio and zero posts, that would include virtually all the SEO spam accounts but pare away most of the real users. It'd be much easier to work through that list. Another useful one would be the set of users who have posted only toots containing links.
@freemo Thanks for trying! I'll do my best with the available tools, and if you do wind up with your hands in the database at some point and wouldn't mind assembling those lists, I'd be happy to work through them.
@khird It wasnt quite that trivial last I looked, but i will be sure to make a second attempt when i have some time.
Luckily since these are non-posting account they arent super critical to have the removed. It would be nice to clean them out though for sure.
@khird I wish. I tried to look into that but as far as I know there isnt a way short of direct DB access. It would have to be coded in.