Get some dead persons without talk pages

Fork of Get all living persons without talk pages by Dreamy Jazz

This query is marked as a draft This query has been published by Dreamy Jazz.

SQL

SELECT page.page_title FROM page INNER JOIN categorylinks ON categorylinks.cl_from = page.page_id WHERE (categorylinks.cl_to = "Year_of_death_missing" or categorylinks.cl_to = "Living_people" or categorylinks.cl_to = "Year of birth missing" or categorylinks.cl_to = "Year of birth missing (living people)" or categorylinks.cl_to = "Date of birth missing" or categorylinks.cl_to = "Date of death missing") and page.page_namespace = "0" and NOT EXISTS (SELECT NULL FROM page p2 WHERE p2.page_namespace = "1" and p2.page_title = page.page_title)

SQL

Checking query status...