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:%")
or (rd_title like "User:%")
or (rd_title like "en:user:%")
or (rd_title like "Användare:%")
or (rd_title like "Uzanto:%")
or (rd_title like "User_talk:%")) or (rd_namespace = 2
         and exists
         (select * from metawiki_p.page
          where rd_title = page_title
          and page_namespace = 2)))
or (page_namespace = 3 and rd_namespace = 0 and (rd_title like "User_talk:%"
or rd_title like "Usuario_Discusión:%"
or rd_title like "nl:Overleg_gebruiker:%"))))
SQL

Checking query status...
