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 > case when MONTH(CURDATE()) = 1 then CONCAT(YEAR(CURDATE()) - 1, '12', LPAD(DAY(CURDATE()), 2, 0), '000000') else CONCAT(YEAR(CURDATE()), LPAD(MONTH(CURDATE()) - 1, 2, 0), LPAD(DAY(CURDATE()), 2, 0), '000000') end
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
SQL

Checking query status...
