State people (2)

SQL

SELECT page.page_title, talk_page.page_title FROM page
LEFT JOIN page AS talk_page ON (talk_page.page_title = CONCAT("Talk:",page.page_title))
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 WHERE page.page_id = categorylinks.cl_from AND (categorylinks.cl_to REGEXP "birth|death" OR categorylinks.cl_to = 'Living_people'))
  	OR exists(SELECT 1 FROM categorylinks WHERE page.page_id = talk_page.page_id AND categorylinks.cl_to = 'WikiProject_Biography_articles')
)
SQL

Checking query status...
