Untitled query #22226

SQL

SELECT
  pg1.page_title
FROM page AS pg1
JOIN templatelinks
ON pg1.page_id = tl_from
WHERE pg1.page_namespace = 0
AND tl_namespace = 10
AND tl_title = 'BLP_unsourced'
AND NOT EXISTS (SELECT
                  1
                FROM page AS pg2
                JOIN categorylinks
                ON pg2.page_id = cl_from
                WHERE pg1.page_title = pg2.page_title
                AND pg2.page_namespace = 0
                AND cl_to = 'Living_people')
AND NOT EXISTS (SELECT
                  1
                FROM page AS pg3
                JOIN categorylinks
                ON pg3.page_id = cl_from
                WHERE pg1.page_title = pg3.page_title
                AND pg3.page_namespace = 0
                AND cl_to = 'Possibly_living_people')
AND EXISTS (SELECT
              1
            FROM page AS pg4
            JOIN categorylinks
            ON pg4.page_id = cl_from
            WHERE pg1.page_title = pg4.page_title
            AND pg4.page_namespace = 0
            AND cl_to RLIKE '^[0-9]{4}_deaths$');
''')
SQL

Checking query status...
