Orphan nonperformant

SQL

# adapted from 76903 that was run on fawiki

select page_title as "orphan page" from page as p
#count(*) from page as p
where 
  page_title LIKE "Q%"
  and NOT (
  page_title IN (
    SELECT pl1.pl_title
    FROM pagelinks AS pl1
    WHERE pl1.pl_namespace = 0
    AND pl1.pl_from_namespace = 0
    AND pl1.pl_from NOT IN (
    SELECT rd_from
    FROM redirect
    WHERE rd_namespace = 0
    AND rd_title = p.page_title
  	)
  )
  OR (
    p1.page_title IN (
      SELECT rd_title
      FROM redirect JOIN page AS p2 ON p2.page_id = rd_from JOIN pagelinks AS pl2 ON p2.page_title = pl2.pl_title
      WHERE rd_namespace = 0
      AND p2.page_is_redirect = 1
      AND p2.page_namespace = 0
      AND pl2.pl_namespace = 0
      AND pl2.pl_from_namespace = 0
    )
  )  
)
order by page_title
limit 1;
SQL

Checking query status...
