Untitled query #9893

SQL

/*USE arwiki_p;
SELECT  page_title,page_namespace ,ll_title  FROM page  JOIN langlinks 
ON page_id = ll_from WHERE page_namespace = 0 AND page_is_redirect = 0 
and ll_lang='en' 
 GROUP BY page_id
 LIMIT 100;*/
 USE enwiki_p;  select cl_to from categorylinks left
SELECT  page_title,page_namespace ,ll_title  FROM page

JOIN langlinks 
ON page_id = ll_from WHERE page_namespace = 0 AND page_is_redirect = 0 
and ll_lang='ar' 
and    cl_to IN (
                SELECT page_title  FROM page  
                WHERE page_namespace = 0 
                AND   page_id IN (
                SELECT ll_from
                FROM langlinks
                WHERE ll_lang = "ar"
                ))
# GROUP BY cl_to
 LIMIT 50;
SQL

Checking query status...
