SQL query to list current users in a journal

[marc]

Collaborative list of spam user patterns

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 use…