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 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",

          "Temporary maintenance holdings/RFD",

          "All redirects for discussion"

        )

        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_%"

                AND NOT cl_to LIKE "%WikiProject_banner_shell%"

            )

            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_%")

          AND NOT lt_title LIKE "%WikiProject_banner_shell%"

      )

    )

  )

ORDER BY

  article.page_title