Untitled query #36993

SQL

use arwiki_p;
/*select distinct p.page_title
from flaggedpage_pending
inner join page p
on p.page_id = fpp_page_id
inner join templatelinks
on tl_from = p.page_id
where p.page_namespace = 0
and p.page_is_redirect = 0
and (select rev_sha1 from revision where rev_id = (select rev_id from revision where rev_page = p.page_id order by rev_timestamp desc limit 1))
=
(select rev_sha1 from revision where rev_id = (select rev_parent_id from revision where rev_page = p.page_id order by rev_timestamp desc limit 1))
limit 10;*/

select page_title from flaggedpages
inner join page
on page_id = fp_page_id 
where page_namespace = 10
and page_is_redirect = 0 
limit 100;
SQL

Checking query status...
