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
EpochFail
.
Toggle Highlighting
SQL
USE wikidatawiki_p; SELECT SUM(page_len < POW(2,3)), SUM(page_len BETWEEN POW(2,3) AND POW(2,4)), SUM(page_len BETWEEN POW(2,4) AND POW(2,5)), SUM(page_len BETWEEN POW(2,5) AND POW(2,6)), SUM(page_len BETWEEN POW(2,6) AND POW(2,7)), SUM(page_len BETWEEN POW(2,7) AND POW(2,8)), SUM(page_len BETWEEN POW(2,8) AND POW(2,9)), SUM(page_len BETWEEN POW(2,9) AND POW(2,10)), SUM(page_len BETWEEN POW(2,10) AND POW(2,11)), SUM(page_len BETWEEN POW(2,11) AND POW(2,12)), SUM(page_len BETWEEN POW(2,12) AND POW(2,13)), SUM(page_len BETWEEN POW(2,13) AND POW(2,14)), SUM(page_len BETWEEN POW(2,14) AND POW(2,15)), SUM(page_len BETWEEN POW(2,15) AND POW(2,16)), SUM(page_len BETWEEN POW(2,16) AND POW(2,17)), SUM(page_len BETWEEN POW(2,17) AND POW(2,18)), SUM(page_len BETWEEN POW(2,18) AND POW(2,19)), SUM(page_len BETWEEN POW(2,19) AND POW(2,20)), SUM(page_len BETWEEN POW(2,20) AND POW(2,21)) FROM page WHERE page_namespace = 0;
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...