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

      )

  )

 AND EXISTS ( 

    SELECT

      1

    FROM

      categorylinks

    WHERE

      articles.page_id = cl_from

      AND (

        cl_to RLIKE "^[^_]+_(births|deaths)$"

        OR cl_to LIKE "%_people"

      )

  )

  AND NOT EXISTS ( 

    SELECT

      1

    FROM

      categorylinks

    WHERE

      articles.page_id = cl_from

      AND (

        cl_to LIKE "%fiction%"

        OR cl_to LIKE "Fiction%"

        OR cl_to LIKE "%character%"

        OR cl_to LIKE "%books%"

        OR cl_to LIKE "Books%"

        OR cl_to LIKE "%films%"

        OR cl_to LIKE "Films%"

        OR cl_to LIKE "%programs%"

         OR cl_to LIKE "Programs%"

                OR cl_to LIKE "%_deities"

                OR cl_to LIKE "%_gods"

                OR cl_to LIKE "%mythology%"

                OR cl_to LIKE "%mythological%"

                OR cl_to LIKE "%mythical%"

        OR cl_to LIKE "%Easton's_Bible_Dictionary"

        OR cl_to LIKE "%Bible_people"

        OR cl_to LIKE "Biblical_people"

        OR cl_to LIKE "Old_Testament_people"

        OR cl_to LIKE "%pejorative%"

        OR cl_to LIKE "Pejorative%"

        OR cl_to LIKE "%_slang" 

        OR cl_to LIKE "%slang_" 

         OR cl_to LIKE "%slur%"

        OR cl_to LIKE "%_memes"  

        OR cl_to LIKE "%_names_%"

        OR cl_to LIKE "%_words%"        

        OR cl_to LIKE "%_of_individual_people"

        OR cl_to LIKE "%_based_on_real_people"

        OR cl_to LIKE "%achievements%"

        OR cl_to LIKE "%organizations%"

        OR cl_to LIKE "%topics%"    

        OR cl_to LIKE "%groups%"

      )

  )

  AND NOT articles.page_title LIKE "%_people"