Articles without talk pages

SQL

SELECT
  page_title
FROM
  page AS articles
  LEFT JOIN page_props ON pp_page = articles.page_id
  AND pp_propname = 'disambiguation'
WHERE
  articles.page_namespace = 0
  AND articles.page_is_redirect = 0
  AND pp_page IS NULL
  AND NOT EXISTS (
    SELECT
      1
    FROM
      page AS talk
    WHERE
      talk.page_namespace = 1
      AND talk.page_title = articles.page_title
  )
  AND NOT EXISTS (
    SELECT
      1
    FROM
      templatelinks
      JOIN linktarget ON lt_id = tl_target_id
    WHERE
      tl_from = articles.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 (page_title LIKE "List_of_%")
  AND NOT (page_title LIKE "Lists_of_%")
  AND NOT EXISTS (
    SELECT
      cl_to
    FROM
      categorylinks
    WHERE
      articles.page_id = cl_from
      AND (
        cl_to IN (
          "Temporary_maintenance_holdings",
          "Candidates_for_speedy_deletion",
          "Requested_RD1_redactions"
        )
        OR cl_to LIKE "%redirects%"
        OR cl_to LIKE "Redirects%"
        OR cl_to LIKE "Lists_of_%"
      )
  )
  ORDER BY page_title
LIMIT 50
SQL

Checking query status...
