SELECT page_title, pp_value FROM page

LEFT JOIN page_props ON pp_page = page_id  AND pp_propname = 'disambiguation'

WHERE page_namespace = 0

  AND pp_page IS NULL

  AND page_is_redirect = 0

  -- AND NOT (page_title LIKE "List_of_%")

  -- AND NOT (page_title LIKE "Lists_of_%")

  AND NOT (page_title LIKE "%_of_%")

  AND NOT (page_title LIKE "%_in_%")

  AND NOT (page_title RLIKE "^[0-9]+s(_BC)?$")

--  AND (page_title RLIKE "^[A-Z].*")

--  AND (page_title LIKE "Autovía_%")

--  AND NOT (page_title RLIKE "^.*_.*$") -- filter

AND NOT EXISTS (SELECT 1 FROM categorylinks WHERE page_id=cl_from AND (

  cl_to = "Articles_with_short_description"

  OR cl_to = "Noindexed_articles"

  OR cl_to LIKE "Redirects_%"

  OR cl_to LIKE "List_%"

  OR cl_to LIKE "Lists_%"

  OR cl_to LIKE "Set_index_%"

  OR cl_to = "Surnames"

))

-- ORDER BY page_title

LIMIT 10000