Pickled accounts report

SQL

use fawiki_p;
set @year = year(curdate());
set @month = month(curdate());
set @gapyears = 2;


  select rev_user_text, str_to_date(left(min(rev_timestamp), 8), '%Y%m%d')
  from revision
  where rev_user <> 0
  and rev_timestamp > concat(@year, LPAD(@month, 2, 0), '01000000')
  and rev_user_text = 'Sinasalek'
  and rev_user not in
  (
    select rev_user
    from revision
    where rev_user <> 0
    and rev_timestamp < concat(@year, LPAD(@month, 2, 0), '01000000')
    and rev_timestamp > concat(@year - @gapyears, LPAD(@month, 2, 0), '01000000')
    and rev_user_text = 'Sinasalek'
  )
  and rev_user in
  (
    select rev_user
    from revision
    where rev_user <> 0
    and rev_timestamp < concat(@year - @gapyears, LPAD(@month, 2, 0), '01000000')
    and rev_user_text = 'Sinasalek'
  )
  group by rev_user_text
SQL

Checking query status...
