Fork of 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 by Modern Sciences
This query is marked as a draft This query has been published by Modern Sciences.

SQL

By running queries you agree to the Labs ToS and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...