Revoked IPBE users on zhwiki

SQL

SELECT COUNT(DISTINCT ufg.ufg_user)
FROM user_former_groups AS ufg
LEFT JOIN user_groups AS ug ON ufg.ufg_user = ug.ug_user
WHERE ufg.ufg_group = 'ipblock-exempt'
  AND NOT EXISTS (
    SELECT 1
    FROM user_groups AS ug2
    WHERE ug2.ug_user = ufg.ufg_user
      AND ug2.ug_group IN ('sysop', 'abusefilter', 'abusefilter-helper', 'templateeditor', 'accountcreator', 'zbureaucrat', 'checkuser', 'eventcoordinator', 'import', 'massmessage-sender', 'oversight', 'transwiki', 'extendedmover', 'patroller', 'interface-admin', 'researcher', 'ipblock-exempt', 'zfilemover')
  );
SQL

Checking query status...
