Untitled query #40827

SQL

use enwiki_p;
select *# p2.page_title, count(cl_to)#distinct
from categorylinks  ,page p1 , page p2# , langlinks
where p1.page_title = cl_to
and p1.page_namespace = 14
and p2.page_id = cl_from 
and p2.page_namespace = 0
#and ll_from = p2.page_id and ll_lang = "ar"

and p2.page_id in (select ff.ll_from from langlinks  ff where ff.ll_lang = "ar" and p2.page_id = ff.ll_from )
#and p1.page_id not in (select ll_from from langlinks where ll_lang = "ar" and cl_from = ll_from)
group by p2.page_id 
#order by count(cl_to) desc
limit 2;
SQL

Checking query status...
