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 p1.page_id not in (select ll_from from langlinks where ll_lang = "ar" and cl_from = ll_from)
# and ll_title in (select arwiki_p.page.page_title from arwiki_p.page where = arwiki_p.page.page_title) 
group by p2.page_id 
#order by count(cl_to) desc
limit 2;
SQL

Checking query status...
