Articles and categories2

SQL

use arwiki_p;
select ips_item_id as iii, ips_site_page as en_title
  from wb_items_per_site
  where ips_site_id = 'enwiki'
SELECT cl_to,  FROM categorylinks 
WHERE    cl_to IN (
                SELECT page_title FROM page 
                WHERE page_namespace = 0 
                AND   page_id IN (
                SELECT ll_from
                FROM langlinks
                WHERE ll_lang = "en"
                ))

and    cl_to not IN (
                SELECT page_title FROM page 
                WHERE page_namespace = 0 
                AND   page_id IN (
                SELECT ll_from
                FROM langlinks
                WHERE ll_lang = "ar"
                ))
 AND   cl_to  IN ( SELECT ll_from FROM langlinks WHERE ll_lang = "en" )
 AND   cl_to NOT IN ( SELECT ll_from FROM langlinks WHERE ll_lang = "ar"  )
GROUP BY cl_to
limit 100;
SQL

Checking query status...
