Global IP block exempt users active on fawiki

Fork of Global IP block exempt users active on fawiki by Huji

This query is marked as a draft This query has been published by Huji.

SQL

select
  gu_name,
  gu_home_db,
  user_editcount,
  case
    when exists (
      select ug_user
      from fawiki_p.user_groups
      where
        ug_user = user_id
        and ug_group in (
          'sysop',
          'ipblock-exempt'
        )
    ) then 1
    else 0
  end as has_local_ipbe,
  max(left(log_timestamp, 4)) as last_blocked_in
from centralauth_p.global_user_groups
join centralauth_p.globaluser
  on gu_id = gug_user
  and gug_group = 'global-ipblock-exempt'
join fawiki_p.user
  on gu_name = user_name
left join fawiki_p.logging
  on log_title = gu_name
  and log_type = 'block'
where user_editcount > 20
group by
  gu_name,
  gu_home_db,
  user_editcount
order by user_editcount

SQL

Checking query status...