Oldest 500 Mainspace articles without a talk page

Fork of Mainspace articles without talk pages (over certain length) by MPGuy2824

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

SQL

SELECT	page_title, min(rev_timestamp) as creationDate
FROM	page AS article
join    revision on page_id=rev_page
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
    	)
group by page_id
order by creationDate asc
limit 10;

SQL

Checking query status...