Frwiki Talk:*/À_faire

SQL

SELECT page_namespace, page_title, LEFT(page_title,CHAR_LENGTH(page_title)-6), CHAR_LENGTH('/À_faire') as afaire
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=LEFT(page_title,CHAR_LENGTH(page_title)-8))
 OR NOT EXISTS (SELECT 1 FROM page mainpage
    WHERE mainpage.page_namespace = talkpage.page_namespace
    AND mainpage.page_title=LEFT(page_title,CHAR_LENGTH(page_title)-8)))
SQL

Checking query status...
