Untitled query #71812

SQL

SELECT article.page_title, article.page_id, talk.page_id AS talk_id FROM page AS article
LEFT JOIN page_props ON pp_page = article.page_id AND pp_propname = 'disambiguation'
INNER JOIN page AS talk ON talk.page_title = article.page_title
WHERE article.page_namespace = 0 AND talk.page_namespace = 1 AND article.page_is_redirect = 0 AND pp_page IS NULL
AND NOT (article.page_title LIKE "List_of_%")
AND NOT (article.page_title LIKE "Lists_of_%")
AND NOT EXISTS (SELECT cl_to FROM categorylinks WHERE article.page_id=cl_from AND cl_to IN ("Temporary_maintenance_holdings", "Candidates_for_speedy_deletion", "Requested RD1 redactions"))
AND NOT EXISTS (SELECT cl_to FROM categorylinks WHERE article.page_id=cl_from AND (cl_to LIKE "%_names" OR cl_to LIKE "_surnames"))
AND NOT EXISTS (SELECT 1 FROM templatelinks JOIN linktarget ON lt_id = tl_target_id WHERE tl_from = article.page_id AND lt_namespace = 10 AND lt_title IN ("Wi", "Surname", "Given_name", "Animal_common_name", "Plant_common_name", "Nickname", "Dmbox"))
AND NOT EXISTS (SELECT 1 FROM templatelinks JOIN linktarget ON lt_id = tl_target_id WHERE tl_from = article.page_id AND lt_namespace = 10 AND (lt_title LIKE "%index%"))
AND NOT EXISTS (SELECT 1 FROM templatelinks JOIN linktarget ON lt_id = tl_target_id WHERE tl_from = article.page_id AND lt_namespace = 10 AND (lt_title LIKE "%redirect%"))
AND NOT EXISTS (SELECT cl_to FROM categorylinks WHERE talk.page_id=cl_from AND cl_to LIKE "%WikiProject_%")
AND NOT EXISTS (SELECT 1 FROM templatelinks JOIN linktarget ON lt_id = tl_target_id WHERE tl_from = talk.page_id AND lt_namespace = 10 AND (lt_title LIKE "%WikiProject_%"))
LIMIT 1000
SQL

Checking query status...
