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

Checking query status...
