use plwiki_p;

​

select f.fr_rev_id, r.rev_id, f.fr_page_id, r.rev_page, p.page_title

from flaggedrevs f

left join revision r on (r.rev_id = f.fr_rev_id)

left join page p on (p.page_id = r.rev_page)

where f.fr_page_id != r.rev_page;