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 = 'Branches_of_biology' 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 = 'Branches_of_biology' ) 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

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 = 'Armenia'
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 = 'Armenia'
) 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...