undeleted pages that were formerly reviewed and appear now unreviewed after undeletion

SQL

use trwiki_p;

select u.user_id, u.user_name, u.user_editcount
, rev.rev_id, rev.rev_page,rev.rev_deleted,rev.rev_len
,p.page_title,p.page_is_new, p.page_touched, p.page_latest, p.page_len
from user u join revision_userindex rev on rev.rev_user=u.user_id
left join page p on p.page_id = rev.rev_page
where u.user_name in ('Mirada')
and rev.rev_parent_id = 0
and (p.page_id is null OR p.page_namespace = 0) 
and (p.page_id is null OR p.page_is_redirect = 0)
and (p.page_id is null OR p.page_title like '%Bey')
limit 10
;

SQL

Checking query status...