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 * from flaggedpages
inner join page
on page_id = fp_page_id 
where page_namespace = 0
and page_is_redirect = 0 
and fp_reviewed = 0
and page_title in (select tl_title from templatelinks where tl_title = page_title and tl_from_namespace = 0 and tl_namespace = 10)
limit 100;
SQL

Checking query status...
