Articles and categories2

SQL

use arwiki_p;

SELECT page_title AS page, (select ll_title from langlinks where ll_from = page_id and ll_lang = 'en') title_en
	FROM (SELECT * FROM page WHERE page_is_redirect = 0 AND page_namespace = 0) AS page

WHERE page_namespace = 0 
AND   page_id IN ( SELECT ll_from  FROM langlinks WHERE ll_lang = "en"  )
AND   page_id IN (SELECT cl_to FROM categorylinks 
         WHERE    cl_to IN (
                SELECT ll_from
                FROM langlinks
                WHERE ll_lang = "en"
         )
)/*
AND page_id  not IN (SELECT cl_to FROM categorylinks 
         WHERE    cl_to IN (
                SELECT ll_from
                FROM langlinks
                WHERE ll_lang = "ar"
         )
)*/
GROUP BY page_title
ORDER BY page_title
limit 10;
SQL

Checking query status...
