Pickled accounts report

SQL

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

select user_id, user_name
from user
join
(
  select rev_user
  from revision
  where rev_timestamp > concat(@year, @month, '01000000')
) recent
on user_id = recent.rev_user
left join
(
  select rev_user
  from revision
  where rev_timestamp < concat(@year, @month, '01000000')
  and rev_timestamp < concat(@year - 1, @month, '01000000')
) gap
on user_id = gap.rev_user
where gap.rev_user is null;

  select concat(@year, LPAD(@month, 2, 0), '01000000')
SQL

Checking query status...
