SQL
x
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= 'ארגז_חול_לתבניות')
and not (page_namespace = 4 and page_title= 'ערכים_לא_קיימים_ומוגנים')
and not (page_namespace = 2 and rd_namespace = 0 and rd_title like "user:%")
and not (page_namespace = 2 and rd_namespace = 0 and rd_title like "User:%")
and not (page_namespace = 2 and rd_namespace = 0 and rd_title like "en:user:%")
and not (page_namespace = 2 and rd_namespace = 0 and rd_title like "Användare:%")
and not (page_namespace = 2 and rd_namespace = 0 and rd_title like "User_talk:%")
and not (page_namespace = 3 and rd_namespace = 0 and rd_title like "User_talk:%")
and not (page_namespace = 3 and rd_namespace = 0 and rd_title like "Usuario_Discusión:%")
and not (page_namespace = 3 and rd_namespace = 0 and rd_title like "nl:Overleg_gebruiker:%")
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.