Untitled query #79187

SQL

select
  page1.page_namespace,
  page1.page_title,
  page2.page_namespace,
  page2.page_title
from
  page page1
  join redirect on page1.page_id = rd_from
  join page page2 on rd_namespace = page2.page_namespace
  and rd_title = page2.page_title
  join pagelinks on page2.page_id = pl_from
where
  page1.page_is_redirect = 1
  and page1.page_namespace = 0
  and page1.page_len >= 0
  and rd_namespace = 0
  and (
    rd_fragment = ''
    or rd_fragment is null
  )
  and pl_namespace = page1.page_namespace
  and pl_title = page1.page_title;
SQL

Checking query status...
