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

SQL

use trwiki_p;
SET @uid = 174948;

select page_title, concat("tr.wikipedia.org/wiki?curid=",rev.rev_page) as url
, concat("https://tr.wikipedia.org/wiki?oldid=",max(fr_rev_id)) as urlrev 
, page_latest - max(fr_rev_id) as sifirmi
from revision_userindex rev
join flaggedrevs on fr_page_id = rev.rev_page
join page on page_id =rev.rev_page

where rev.rev_user = @uid and rev.rev_parent_id = 0
and fr_rev_id not in (select fp_page_id from flaggedpages)
group by rev.rev_page
order by abs(4) desc, 3 asc
;


/*

select *
from (select concat("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_len as rev_len
, replace(p.page_title,"_"," ") as sayfa,p.page_is_new as yeni, p.page_latest as sonversiyon, 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_namespace = 0 and p.page_is_redirect = 0 
--     and p.page_title rlike 'Aspar'
      )
     --  OR p.page_id is null 
     )
order by rev_len desc, sonversiyon asc ) 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...
