Untitled query #22015

SQL

/*SELECT CONCAT("Category:",page_title) AS titl FROM page 
WHERE page_title like "%Yemen%" 
AND page_namespace = 14 
AND page_id not IN ( SELECT ll_from FROM langlinks WHERE ll_lang = "ar" ) 
GROUP BY page_title
limit 30;*/
SELECT CONCAT("Category:",cl_to) AS titl FROM categorylinks
WHERE cl_to like "%Yemen%" 
AND cl_to IN (SELECT page_title FROM page WHERE page_id IN ( SELECT ll_from FROM langlinks WHERE ll_lang = "ar" )) 
AND cl_to NOT IN ( SELECT ll_from FROM langlinks WHERE ll_lang = "ar"  )  
GROUP BY cl_to 
limit 10;
SQL

Checking query status...
