etwiki redirections to red links

SQL

-- Hewiki redirections to red links
use etwiki_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 "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...
