Untitled query #79179

SQL

select
  categorylinks1.cl_to,
  page1.page_namespace,
  page1.page_title,
  page2.page_namespace,
  page2.page_title
from
  categorylinks categorylinks1
  join page page1 on categorylinks1.cl_from = page1.page_id
  join pagelinks on page1.page_namespace = pl_namespace
  and page1.page_title = pl_title
  join page page2 on pl_from = page2.page_id
where
  categorylinks1.cl_to in (
    'Redirects_from_incorrect_names',
    'Redirects_from_incorrect_disambiguation',
    'Redirects_from_incomplete_names',
    'Redirects_from_incorrect_hyphenation',
    'Redirects_from_miscapitalisations',
    'Redirects_from_misspellings',
    'Redirects_from_subsidiary_titles'
  )
  and page1.page_namespace not in (10, 14)
  and page2.page_namespace = 0;
SQL

Checking query status...
