Pickled accounts report

SQL

use fawiki_p;
set @year = year(curdate());
set @month = month(curdate());
set @gapyears = 2;
/*
select user_id, user_name
from user
where user_id in
(
  select rev_user
  from revision
  where rev_timestamp > concat(@year, LPAD(@month, 2, 0), '01000000')
)
and user_id not in
(
  select rev_user
  from revision
  where rev_timestamp < concat(@year, LPAD(@month, 2, 0), '01000000')
  and rev_timestamp > concat(@year - @gapyears, LPAD(@month, 2, 0), '01000000')
)
and user_id in
(
  select rev_user
  from revision
  where rev_timestamp < concat(@year - @gapyears, LPAD(@month, 2, 0), '01000000')
);
*/
  select *
  from revision
  where rev_user <> 0
  and rev_timestamp > concat(@year, LPAD(@month, 2, 0), '01000000')
  limit 100
  /*and rev_user not in (
  select distinct rev_user
  from revision
  where
  and rev_timestamp < concat(@year, LPAD(@month, 2, 0), '01000000')
  and rev_timestamp > concat(@year - @gapyears, LPAD(@month, 2, 0), '01000000')
  )*/
SQL

Checking query status...
