Untitled query #36993

SQL

use arwiki_p;
select *
from flaggedpage_pending
inner join page p
on p.page_id = fpp_page_id
inner join templatelinks
on tl_from = p.page_id
inner join page p2
on p2.page_title = tl_title
where p.page_namespace = 0
and p.page_is_redirect = 0
and p.page_namespace = 10
and p.page_is_redirect = 0
and (select rev_sha1 from revision where rev_id = (select rev_id from revision where rev_page = p2.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 = p2.page_id order by rev_timestamp desc limit 1))
limit 10;
SQL

Checking query status...
