Create view noext as select page_namespace,page_id,page_title from page where page_namespace = 0 AND page_id not in (select el_from from externallinks where 1) order by page_title asc limit 10000;

Select page_title from noext;