Untitled query #79860

SQL

select
  page2.page_namespace as source_ns,
  page2.page_title as source_title,
  page1.page_namespace as redir_ns,
  page1.page_title as redir_title
from
  categorylinks
  join page page1 on cl_from = 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
  cl_to = 'Wikipedia_interwiki_soft_redirects'
  and page1.page_namespace in (0, 4, 6, 8, 10, 12, 100, 118, 710, 828)
  and (
    page1.page_namespace <> 4
    or page1.page_title <> 'ReFill'
  );
SQL

Checking query status...
