Fork of Articles without talk pages by The Anome
This query is marked as a draft This query has been published by Qwerfjkl.

SQL

AخA
 
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
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query
All SQL code is licensed under CC0 License.

Checking query status...