@LMAO is flooding the site with random communities because they’re salty about being banned for claiming too many community names. They claim they’re trying to “fuck your entire site up” but I imagine it’s a relatively quick fix to delete all the communities they’re creating, LMAO.
Any rdbms should be able to handle it and it should be trivial to select all communities where mod_id = troll.
That’s what I meant: any variable that they all have in common should be what is selected. When we were dealing with spam accounts on NormalCity, I mostly used particular patterns in the email addresses to find problem accounts. Funnily enough, some of the accounts had flat out invalid email addresses that had no .tld, and plenty had long sequences of numbers that were easy to isolate.