Untitled query #34456

SQL

use enwiki_p;
select concat('Category:', page_title) category_name, count(*) pages
from
(
select cl_from
from categorylinks
join page
on page_id = cl_from
and page_namespace = 14
where cl_to = 'Armenian'
union
select c1.cl_from
from categorylinks c1
join page p1
on c1.cl_to = p1.page_title
and p1.page_namespace = 14
join page p2
on p2.page_id = c1.cl_from
and p2.page_namespace = 14
join categorylinks c2
on c2.cl_from = p1.page_id
and c2.cl_to = 'Armenian'
) t
join page
on page_id = t.cl_from
left join categorylinks cl
on cl.cl_to = page_title
and cl_type = 'page'
left join langlinks
on ll_from = t.cl_from
and ll_lang = 'fa'
where ll_lang is null
group by page_title
order by pages desc
SQL

Checking query status...
