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:%"))))

​