Wikimedia Bugzilla is closed!

Existing query (Erwin85):

        SELECT count(1) as count, user_name
        FROM nlwiki_p.logging
        LEFT JOIN nlwiki_p.user
        ON log_user = user_id
        WHERE log_type = 'patrol'
        AND NOT EXISTS (SELECT 1 FROM nlwiki_p.user_groups
                        WHERE ug_user = user_id
                        AND ug_group = 'bot')
        GROUP BY log_user
        ORDER BY count DESC LIMIT 50;"