Replicas browser and optimizer
How many stub categories is an article in on fawiki?
This query is marked as a draft
This query has been published
use fawiki_p; select page_title, sum(stubcat) as stubcatcount from ( select page_title, case when cl_to is null then 0 else 1 end as stubcat from page left join categorylinks on cl_from = page_id and cl_to like '%\_خرد\_%' where page_namespace = 0 ) T group by page_title having sum(stubcat) > 3 order by sum(stubcat) desc
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