Orphaned Talkpages (English Wikipedia)

SQL

#=============
#MAINSPACE
#=============
select p1.page_title, p1.page_namespace from page p1
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
union
#=============
#TEMPLATE
#=============
select p1.page_title, p1.page_namespace from page p1
left join (
    select page_title from page
    where page_namespace = 10
) p2
on p1.page_title = p2.page_title
where
	p1.page_namespace = 11
    and p1.page_title not like "%/Archive%"
    and p2.page_title is null
union
#=============
#HELP
#=============
select p1.page_title, p1.page_namespace from page p1
left join (
    select page_title from page
    where page_namespace = 12
) p2
on p1.page_title = p2.page_title
where
	p1.page_namespace = 13
    and p1.page_title not like "%/Archive%"
    and p2.page_title is null
union
#=============
#category
#=============
select p1.page_title, p1.page_namespace from page p1
left join (
    select page_title from page
    where page_namespace = 14
) p2
on p1.page_title = p2.page_title
where
	p1.page_namespace = 15
    and p1.page_title not like "%/Archive%"
    and p2.page_title is null
SQL

Checking query status...
