Orphaned Talkpages (simplewiki)

SQL

select p1.page_title 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 p2.page_title is null
limit 10
#SELECT l.log_title, l.log_timestamp FROM logging l
#LEFT JOIN (
#  SELECT page_title FROM page p
#  WHERE page_namespace = 0
#) p
#ON l.log_title=p.page_title 
#WHERE 
#	log_type = "create"
#	AND p.page_title IS NULL
#    AND log_namespace = 1
#    AND log_timestamp >= "20231000000000" 
#ORDER BY log_timestamp DESC

SQL

Checking query status...