Authored By

	stwalkerster
	May 10 2016, 10:11 PM

Size

538 B

Referenced Files

None

Subscribers

None

View Options

	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
	;

File Metadata