Untitled query #4983

SQL

use arwiki_p;
select page_namespace, page_title, rd_namespace, rd_title from page join redirect
where rd_from = page_id
and not exists
(select * from page as p1
 where p1.page_title = rd_title
 and p1.page_namespace = rd_namespace)
and not (page_namespace = 0 and page_title= 'וק:חס')
and not (page_namespace = 0 and page_title= 'וק:יומן_ש')
and not (page_namespace = 4 and page_title= 'ארגז_חול_לתבניות')
and not (page_namespace = 4 and page_title= 'ערכים_לא_קיימים_ומוגנים')
and not (page_namespace = 2 and rd_namespace = 0 and rd_title like "user:%")
and not (page_namespace = 2 and rd_namespace = 0 and rd_title like "User:%")
and not (page_namespace = 2 and rd_namespace = 0 and rd_title like "en:user:%")
and not (page_namespace = 2 and rd_namespace = 0 and rd_title like "Användare:%")
and not (page_namespace = 2 and rd_namespace = 0 and rd_title like "Uzanto:%")
and not (page_namespace = 2 and rd_namespace = 0 and rd_title like "User_talk:%")
and not (page_namespace = 3 and rd_namespace = 0 and rd_title like "User_talk:%")
and not (page_namespace = 3 and rd_namespace = 0 and rd_title like "Usuario_Discusión:%")
and not (page_namespace = 3 and rd_namespace = 0 and rd_title like "nl:Overleg_gebruiker:%")
and not (page_namespace = 2 and rd_namespace = 2
         and exists
         (select * from metawiki_p.page as p1
          where rd_title = p1.page_title
          and p1.page_namespace = 2))
SQL

Checking query status...
