Untitled query #12262

SQL

USE enwiki_p;
        SELECT  page_title 
     , (select ll_title from langlinks where ll_from = page_id and ll_lang = 'ar') as title_ar
        FROM page
        WHERE page_namespace = 0
   AND page_title IN (   
        SELECT  page_title  
        FROM page
        WHERE page_namespace = 14
   AND page_title  NOT IN (
        SELECT DISTINCT page_title
        FROM langlinks
        LEFT JOIN page ON page_id = ll_from
        WHERE ll_lang = "ar"
        AND page_namespace = 14
        )   
        )
   AND page_title  IN (
        SELECT DISTINCT page_title
        FROM langlinks
        LEFT JOIN page ON page_id = ll_from
        WHERE ll_lang = "ar"
        AND page_namespace = 0
        )
        
ORDER BY page_title
limit 20;
SQL

Checking query status...
