Blocks performed in fawiki since 2014

SQL

use fawiki_p;
select
  log_user_text,
  count(*),
  case
    when exists (
      select null from user_groups
      where ug_user = log_user
      and ug_group = 'eliminator'
    ) then 1
    else 0
  end as Eliminator,
  case
    when exists (
      select null from user_groups
      where ug_user = log_user
      and ug_group = 'sysop'
    ) then 1
    else 0
  end as Sysop,
  case
    when exists (
      select null from user_former_groups
      where ufg_user = log_user
      and ufg_group = 'eliminator'
    ) then 1
    else 0
  end as FormerEliminator,
  case
    when exists (
      select null from user_former_groups
      where ufg_user = log_user
      and ufg_group = 'sysop'
    ) then 1
    else 0
  end as FormerSysop
from logging
where log_type = 'block'
and log_action = 'block'
and log_timestamp > '20160101000000'
and log_user is not null -- hidden from public
group by log_user
order by 2 desc;
SQL

Checking query status...
