I’m running OJS 3.1.2 and I’m looking how to build a query that will get a count for the number of submissions that a user is associated with.
So counting the number of submissions a user has submitted or reviewed or commented on etc.
The reason I ask is we have a large number of spam user’s we want to remove. The problem is I am having trouble identifying those users. Many almost look legitimate. So if I can identify user’s that have submission counts of 0 then even if I accidentally merge (remove) a legitimate user the consequences would be minimal.