SQL query in OJS 3.3.x to identify spam registrants

[marc]

Hi Obi,

Not exactly what you are looking for, but this list include queries to find spam patterns:

Collaborative list of spam user patterns

Whether you’ve inherited a new magazine or it’s time to put your house in order, in the forum you can find several good threads on how to deal with spam users but I miss an unified and updated list of spam patterns like the one @jmacgreg started in How do I combat spam?, so, here you have a forum-wiki-page here with an initial compilation that could be collectively extended/enriched. I tried to make it compact and with same structure to facilitate the reading and are numbered for an easy refere…

Cheers,
m.