Orphaned Talkpages (simplewiki)

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 like "%/Archive%"
    and p2.page_title is null
union
#=============
#PROJECT
#=============
select p1.page_title, p1.page_namespace from page p1
left join (
    select page_title from page
    where page_namespace = 4
) p2
on p1.page_title = p2.page_title
where
	p1.page_namespace = 5
    and p1.page_title not like "%/Archive%"
    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...
