Query for Tisfoon

SQL

use enwiki_p;
select cl_from
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
left join lang_links
on ll_from = cl_from
and ll_lang = 'fa'
where ll_lang is null
SQL

Checking query status...
