Untitled query #76100

SQL

select 
  concat("[[",REPLACE(page_title,"_"," "),"]]") as "page title", (
  select revision.rev_page from flaggedrevs 
  inner join user on revision.rev_page = flaggedrevs.fr_rev_id
  where fr_page_id = page_id
  order by fr_timestamp asc
  limit 1) as "user which reviewed"
from page
where page.page_is_redirect = 0
and page.page_namespace = 0
and page_id in (select fp_page_id from flaggedpages where fp_page_id = page_id)
and page_title in (
  select pl_title from pagelinks
  where pl_from = 1149712
  and pl_from_namespace = 4
  and pl_namespace = 0
);
SQL

Checking query status...
