Orphaned Talkpages (English Wikipedia)

SQL

#=============
#MAINSPACE
#=============
select p1.page_title, p1.page_namespace from page p1
left join redirect rd
on p1.page_id = rd.rd_from
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
    and rd.rd_from is null
    and p1.page_id not in (
      	select cl.cl_from from categorylinks cl
     	where cl.cl_to = "Wikipedia_orphaned_talk_pages_that_should_not_be_speedily_deleted"
    )
union
#=============
#CATEGORY
#=============
select p1.page_title, p1.page_namespace from page p1
left join redirect rd
on p1.page_id = rd.rd_from
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 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
    and rd.rd_from is null
    and p1.page_id not in (
      	select cl.cl_from from categorylinks cl
     	where cl.cl_to = "Wikipedia_orphaned_talk_pages_that_should_not_be_speedily_deleted"
    )
SQL

Checking query status...
