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 = 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:%")))) and
not (page_namespace = 4 and page_title in ('ארגז_חול_לתבניות', 'ערכים_לא_קיימים_ומוגנים'))
SQL

Checking query status...
