Articles and categories2

SQL

use arwiki_p;

SELECT page_title AS page, pp_value AS item
	FROM (SELECT * FROM page WHERE page_is_redirect = 0 AND page_namespace = 0) AS page
	JOIN (SELECT * FROM page_props WHERE pp_propname = 'wikibase_item') AS props
                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...
