Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Dalinni
.
Toggle Highlighting
SQL
select page_title, count(distinct cl.cl_to), sum(cat.cat_pages) from page join ( select cl_from as cl_key, cl_to, cl_timestamp, cl_type from categorylinks ) as cl on cl.cl_key = page_id join ( select cat_title as cat_key, cat_pages from category ) as cat on cat.cat_key = cl.cl_to where cl_to != 'Unprintworthy_redirects' and cat.cat_pages > 300 group by page_id limit 10
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...