Untitled query #89565

SQL

USE ruwiki_p;
SELECT     subpage.page_title AS orphan_subpage
FROM     page AS subpage
LEFT JOIN     page AS parent
ON     parent.page_title = SUBSTRING_INDEX(subpage.page_title, '/', 1)    AND parent.page_namespace = subpage.page_namespace
LEFT JOIN     page AS main_namespace
ON     main_namespace.page_title = subpage.page_title    AND main_namespace.page_namespace = 0 -- Main namespace
WHERE     subpage.page_namespace = 1 -- Namespace "Talk:"    
AND subpage.page_title LIKE "%/%" -- Identify subpages (contain '/')    
AND parent.page_id IS NULL -- Ensure the parent page doesn't exist    
AND main_namespace.page_id IS NULL -- Exclude pages that exist in the main namespace
LIMIT 100;
SQL

Checking query status...
