Hewiki redirections to red links

SQL

use hewiki_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 in('ארגז_חול_לתבניות', 'ערכים_לא_קיימים_ומוגנים')
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...
