SELECT

  article.page_namespace, article.page_title

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