Short-title articles 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'
  LEFT JOIN page AS talk ON talk.page_title = article.page_title AND talk.page_namespace = 1 AND talk.page_is_redirect = 0
WHERE
  article.page_namespace = 0
  AND article.page_title RLIKE "^.{,6}$"
  AND pp_page IS NULL
  AND article.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 (
    (talk.page_id IS NULL)
    OR (
      (talk.page_id IS NOT NULL)
      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
SQL

Checking query status...
