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 enwiki_p; select stubcatcount, count(*) as freq from ( 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 '%\_stubs' where page_namespace = 0 and page_is_redirect = 0 ) T group by page_title ) S group by stubcatcount
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