Untitled query #49023

SQL

USE enwiki_p;
ANALYZE SELECT page.page_title, CONCAT("Talk:", page.page_title)
FROM page
WHERE 
	page.page_namespace = 0
	AND page.page_is_redirect = 0
	AND page.page_title REGEXP '\\((Alabama|Alaska|Arizona|Arkansas|California|Colorado|Connecticut|Delaware|Florida|Georgia|Hawaii|Idaho|Illinois|Indiana|Iowa|Kansas|Kentucky|Louisiana|Maine|Maryland|Massachusetts|Michigan|Minnesota|Mississippi|Missouri|Montana|Nebraska|Nevada|New_Hampshire|New_Jersey|New_Mexico|New_York|North_Carolina|North_Dakota|Ohio|Oklahoma|Oregon|Pennsylvania|Rhode_Island|South_Carolina|South_Dakota|Tennessee|Texas|Utah|Vermont|Virginia|Washington|West_Virginia|Wisconsin|Wyoming)\\)'
	AND exists(
		SELECT 1
        FROM categorylinks 
        JOIN page p0 ON cl_from = p0.page_id
        WHERE 
			p0.page_title = page.page_title
          	AND p0.page_namespace IN (0, 1)
          	AND (
				cl_to IN ("WikiProject_Biography_articles", "Living_people")
				OR cl_to REGEXP "birth|death"
			)    
        )
SQL

Checking query status...
