Untitled query #84707

SQL

select 
  REPLACE(page_title,"_"," ") as "page_title", (
  select user_name from flaggedrevs 
  inner join user on user.user_id = flaggedrevs.fr_user
  where fr_rev_id = page_latest
  order by fr_timestamp asc
  limit 1) as "user_reviewed"
from page
where page.page_is_redirect = 0
and page.page_namespace = 0
and page_id in (select fr_page_id from flaggedrevs where fr_rev_id = page_latest)
and page_title in (
select lt_title from pagelinks 
inner join linktarget ON lt_id = pl_target_id
  where pl_from = 1149712
  and pl_from_namespace = 4
  and lt_namespace = 0
);
SQL

Checking query status...
