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;*/
SELECT DISTINCT
  cl_to
FROM categorylinks AS cat
JOIN page AS pg1
ON cat.cl_from = pg1.page_id
WHERE cat.cl_to like "%Yemen%" #page_namespace = 14
AND pg1.page_id IN ( SELECT ll_from FROM langlinks WHERE ll_lang = "ar" )
AND cat.cl_to NOT IN ( SELECT ll_from FROM langlinks WHERE ll_lang = "ar"  )  
LIMIT 10;
SQL

Checking query status...
