Orphaned Talkpages (English Wikipedia)

SQL

#=============
#MAINSPACE
#=============
select p1.page_title, p1.page_namespace, rd_id from page p1
join redirect rd
on p1.page_id = rd.rd_id
left join (
    select page_title from page
    where page_namespace = 0
) p2
on p1.page_title = p2.page_title
where
	p1.page_namespace = 1
    and p1.page_title not regexp "/.*$"
    #and p1.page_title not regexp "/[Aa]rchive_?\d*$"
    #and p1.page_title not regexp "/[Cc]omments?$"
    #and p1.page_title not regexp "/[Tt]o[-_]?[Dd]o$"
    #and p1.page_title not regexp "/[Tt]o[-_]?[Dd]o$"
    #and p1.page_title not like "%/GA%"
    and p2.page_title is null
limit 10
SQL

Checking query status...
