Collaborative list of spam user patterns

Software Support
, ,
4

This is an old thread but very nice work from Marc.

The search of users by role applies to OJS2. For OJS3 this would be

SELECT username FROM users 
WHERE user_id NOT IN (SELECT user_id FROM user_user_groups)

You could also consider stage_assignments and review_assignments:

SELECT username FROM users 
WHERE user_id NOT IN (SELECT user_id FROM user_user_groups) 
AND user_id NOT IN (SELECT user_id FROM stage_assignments) 
AND user_id NOT IN (SELECT reviewer_id FROM review_assignments) 
AND user_id NOT IN (SELECT editor_id FROM edit_decisions)
2 Likes