EXPLAIN
SELECT page_id, page_namespace, page_title
FROM page
	LEFT JOIN pagelinks ON pl_namespace = page_namespace AND pl_title = page_title
	LEFT JOIN templatelinks ON tl_namespace = page_namespace AND tl_title = page_title
  LEFT JOIN page_props ON pp_page = page_id AND pp_propname = 'disambiguation'
  LEFT JOIN categorylinks ON cl_from = page_id AND cl_to = 'All_set_index_articles'
WHERE	pl_namespace IS NULL
	AND page_namespace = 0
	AND page_is_redirect = 0
	AND tl_namespace IS NULL
  AND pp_propname IS NULL
  AND cl_to IS NULL
;