Replicas browser and optimizer
This query is marked as a draft
This query has been published
select page_title, count(cl_from) from page inner join categorylinks on cl_to = page_title where page_id not in (select cl_from from categorylinks where cl_to = "Hidden_categories") and cl_from in (select ll_from from langlinks where ll_from = cl_from and ll_lang = "ar") and page_id not in (select ll_from from langlinks where ll_from = page_id and ll_lang = "ar") and page_namespace = 14 and page_is_redirect = 0 group by page_title having count(cl_from)>100 limit 500;
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in