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

SQL

use trwiki_p;

select *
from (select concat("http://tr.wikipedia.org/wiki?curid=",rev.rev_page) as url
, u.user_id as id, u.user_name as ad, u.user_editcount as ec
, rev.rev_id as revid, rev.rev_page as pid,rev.rev_deleted as rev_deleted,rev.rev_len as rev_len
, p.page_title as sayfa,p.page_is_new as yeni, p.page_touched as touched, p.page_latest as sonver, p.page_len as uzunluk
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_is_redirect = 0 
--     and p.page_title rlike 'Aspar'
--     )
     )
order by rev_len desc ) as p0 join revision_userindex r on r.rev_page = p0.pid
join user u2 on u2.user_id = r.rev_user

where r.rev_user>0
and u2.user_editcount > 1000

-- group by r.rev_user, p0.pid

limit 10
;

SQL

Checking query status...