Frwiki Talk:*/À_faire

SQL

SELECT page_namespace, page_title, SUBSTRING(page_title,1,CHAR_LENGTH(page_title)-7)
FROM page talkpage
WHERE talkpage.page_title LIKE '\'%/À_faire'
AND talkpage.page_namespace IN (1,5,11,15,101,119,711,829)
AND (NOT EXISTS (SELECT 1 FROM page mainpage
    WHERE mainpage.page_namespace = talkpage.page_namespace-1
    AND mainpage.page_title=SUBSTRING(page_title,1,CHAR_LENGTH(page_title)-9))
 OR NOT EXISTS (SELECT 1 FROM page mainpage
    WHERE mainpage.page_namespace = talkpage.page_namespace
    AND mainpage.page_title=SUBSTRING(page_title,1,CHAR_LENGTH(page_title)-9)))
SQL

Checking query status...
