Users whose global rights were revoked locally

SQL

select
  actor_name, gug_group
from
  actor
  join centralauth_p.globaluser on gu_name = actor_name
  join centralauth_p.global_user_groups on gug_user = gu_id
where
  (
  gug_group = "global-rollbacker"
  and exists (select 1 from user_former_groups where ufg_user=actor_user and ufg_group="rollbacker")
  and not exists (select 1 from user_groups where ug_user=actor_user and ug_group="rollbacker")
  ) 
  or (
  gug_group= "global-interface-editor" 
  and exists (select 1 from user_former_groups where ufg_user=actor_user and (ufg_group="interface-admin" || ufg_group="sysop")))

SQL

Checking query status...