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

SQL

use trwiki_p;

select concat('tr.wikipedia.org/wiki?cur_id=',rev.rev_page) as url
, 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 = -44 and p.page_is_redirect = 0 
--      and p.page_title like '%Bey'
     ))
order by rev_len desc
;

SQL

Checking query status...