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
  left join categorylinks categorylinks2 on page1.page_id = categorylinks2.cl_from
  and categorylinks2.cl_to = 'Redirect_templates'
  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)
    or categorylinks2.cl_to is null
  )
  and page2.page_namespace = 0;
SQL

Checking query status...
