Untitled query #40827

SQL

use enwiki_p;

select distinct p2.page_title, count(cl_to)
from categorylinks 
inner join page p1 on p1.page_title = cl_to
inner join page p2 on p2.page_id = cl_from 
inner join langlinks on ll_from = p2.page_id
where p1.page_namespace = 14
and p2.page_namespace = 0
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...
