How many AF blocks are later unblocked?

SQL

use fawiki_p;
select
  max(l1.log_id), max(l1.log_timestamp), l1.log_title,
  max(l2.log_id), max(l2.log_timestamp), l2.log_user
from
(
select
  log_id,
  log_timestamp,
  log_title
from logging_userindex
where
  log_type = 'block'
  and log_action = 'block'
  and log_user = 427882 -- User:Abuse filter
order by log_id desc
limit 1000
) l1
left join logging_logindex l2
  on l2.log_type = 'block'
  and l2.log_action = 'unblock'
  and l2.log_title = l1.log_title -- same target account
  and l2.log_namespace = 2 -- to allow using the page_time index
where
    l2.log_timestamp > l1.log_timestamp
group by
  l1.log_title,
  l2.log_user
SQL

Checking query status...
