EXPLAIN
SELECT 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
WHERE	pl_namespace IS NULL
	AND page_namespace = 0
	AND page_is_redirect = 0
	AND tl_namespace IS NULL