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

​