PCR bot find revs that should have been auto accepted

SQL

select outer_rev.rev_id from revision as outer_rev
inner join actor on outer_rev.rev_actor=actor_id
inner join user on user_id=actor_user
left join user_groups on ug_user=user_id 
where (ug_group='extendedconfirmed' or ug_group='confirmed' or ug_group='autoconfirmed' or ug_group='sysop'or ug_group='bot')
and (select inner_rev.rev_id from revision as inner_rev
    inner join actor on inner_rev.rev_actor=actor_id
	inner join user on user_id=actor_user
	left join user_groups on ug_user=user_id 
	where (ug_group='extendedconfirmed' or ug_group='confirmed' or ug_group='autoconfirmed' or ug_group='sysop'or ug_group='bot')
    and inner_rev.rev_id=outer_rev.rev_parent_id
    ) is not NULL
and outer_rev.rev_page='20316' and outer_rev.rev_id>1012060364
SQL

Checking query status...
