Oldest 500 Mainspace articles without a talk page

SQL

SELECT	page_title, left(min(rev_timestamp),8) 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
    	( -- talk page doesn't exist
        	SELECT 1
          	FROM 	page AS talkpage
          	WHERE 	talkpage.page_title=article.page_title
        	AND 	talkpage.page_namespace=1
          	LIMIT 1
    	)
		AND NOT EXISTS
    	( -- ignoring disambiguations
	        SELECT 1
        	FROM 	page_props AS props
        	WHERE 	props.pp_propname = 'disambiguation'
        	AND   	props.pp_page = article.page_id
          	LIMIT 1
    	)
		AND NOT EXISTS
    	( -- ignoring a few categories
        	SELECT 1
          	FROM 	categorylinks
          	WHERE 	categorylinks.cl_from=article.page_id
			AND 	categorylinks.cl_to IN ( "All_set_index_articles", "All_redirects_for_discussion", "Redirects_to_Wiktionary")
          	LIMIT 1
    	)
group by page_id
order by creationDate asc
limit 500;
SQL

Checking query status...
