Potential candidates for autopatrol right at FA WP

SQL

use fawiki_p;
select rev_user, rev_user_text, case when ufg_group is null then '{{خیر|بله}}' else '' end as lostautopatrol, count(*) cnt
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

SQL

Checking query status...