Potential candidates for autopatrol right at FA WP

SQL

use fawiki_p;
/*
select rev_user, rev_user_text, count(*) cnt, case when ufg_group is null then '' else '{{خیر|بله}}' end as lostautopatrol
from revision
left join user_former_groups
on rev_user = ufg_user
and ufg_group = 'autopatrolled'
where rev_parent_id = 0
and rev_timestamp > '20170201000000'
and rev_user not in (
  select ug_user
  from user_groups
  where ug_group in ('autopatrolled', 'sysop', 'bot')
)
and rev_user <> 0 /* anonymous user */
-- and rev_user <> 374638 /* پیام به کاربر جدید */
-- group by rev_user_text, ufg_group
-- having cnt > 50
-- order by cnt desc
select case when month(curdate()) = 1 then
  CONCAT(YEAR(CURDATE()) - 1, '12', LPAD(DAY(CURDATE()), 2, 0), '000000')
else
  CONCAT(YEAR(CURDATE()), LPAD(MONTH(CURDATE()), 2, 0), LPAD(DAY(CURDATE()), 2, 0), '000000')
end
SQL

Checking query status...
