Mainspace articles without talk pages

This query is marked as a draft This query has been published by Thparkth.

https://en.wikipedia.org/wiki/Wikipedia_talk:Database_reports#Request:_Mainspace_pages_without_talk_pages

SQL

SELECT	page_title
FROM	page AS article
WHERE	article.page_is_redirect=0
		AND	article.page_namespace=0
		AND NOT EXISTS
    	(
        	SELECT 1
          	FROM 	page AS talkpage
          	WHERE 	talkpage.page_title=article.page_title
        	AND 	talkpage.page_namespace=1
          	LIMIT 1
    	)
		AND NOT EXISTS
    	(
	        SELECT 1
        	FROM 	page_props AS props
        	WHERE 	props.pp_propname = 'disambiguation'
        	AND   	props.pp_page = article.page_id
          	LIMIT 1
    	)
LIMIT 10;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...