Articles with talk pages but not assigned to WikiProjects

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 pp_page IS NULL
  AND article.page_is_redirect = 0
  AND talk.page_is_redirect = 0
  AND NOT (article.page_title LIKE "List_of_%")
  AND NOT (article.page_title LIKE "Lists_of_%")
  AND NOT EXISTS (
    SELECT
      1
    FROM
      categorylinks
    WHERE
      article.page_id = cl_from
      AND (
        cl_to IN (
          "Temporary_maintenance_holdings",
          "Candidates_for_speedy_deletion",
          "Requested_RD1_redactions"
        )
        OR cl_to LIKE "%_names"
        OR cl_to LIKE "%_surnames"
        OR cl_to LIKE "Lists_of_%"
      )
  )
  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"
        )
        OR lt_title LIKE "%index%"
        OR lt_title LIKE "%redirect%"
      )
  )
  AND NOT EXISTS (
    SELECT
      1
    FROM
      categorylinks
    WHERE
      talk.page_id = cl_from
      AND (
        cl_to LIKE "%WikiProject_%"
        OR cl_to LIKE "%-Class_%_articles"
        OR cl_to LIKE "%-importance_%_articles"
        OR cl_to LIKE "%-priority_%_articles"
        OR cl_to LIKE "Unassessed_%_articles"
      )
  )
  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_%")
  )
  ORDER BY article.page_title
  
 LIMIT 50
SQL

Checking query status...
