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
JPxG
.
Toggle Highlighting
SQL
SELECT page_title AS "Mainspace", page_len FROM page WHERE page_namespace = "0" ORDER BY page_len DESC LIMIT 1000; SELECT page_title AS "Talk", page_len FROM page WHERE page_namespace = "1" ORDER BY page_len DESC LIMIT 1000; SELECT page_title AS "User", page_len FROM page WHERE page_namespace = "2" ORDER BY page_len DESC LIMIT 1000; SELECT page_title AS "User talk", page_len FROM page WHERE page_namespace = "3" ORDER BY page_len DESC LIMIT 1000; SELECT page_title AS "Wikipedia", page_len FROM page WHERE page_namespace = "4" ORDER BY page_len DESC LIMIT 1000; SELECT page_title AS "Wikipedia talk", page_len FROM page WHERE page_namespace = "5" ORDER BY page_len DESC LIMIT 1000; SELECT page_title AS "File", page_len FROM page WHERE page_namespace = "6" ORDER BY page_len DESC LIMIT 1000; SELECT page_title AS "File talk", page_len FROM page WHERE page_namespace = "7" ORDER BY page_len DESC LIMIT 1000; SELECT page_title AS "MediaWiki", page_len FROM page WHERE page_namespace = "8" ORDER BY page_len DESC LIMIT 1000; SELECT page_title AS "MediaWiki talk", page_len FROM page WHERE page_namespace = "9" ORDER BY page_len DESC LIMIT 1000; SELECT page_title AS "Template", page_len FROM page WHERE page_namespace = "10" ORDER BY page_len DESC LIMIT 1000; SELECT page_title AS "Template talk", page_len FROM page WHERE page_namespace = "11" ORDER BY page_len DESC LIMIT 1000; SELECT page_title AS "Help", page_len FROM page WHERE page_namespace = "12" ORDER BY page_len DESC LIMIT 1000; SELECT page_title AS "Help talk", page_len FROM page WHERE page_namespace = "13" ORDER BY page_len DESC LIMIT 1000; SELECT page_title AS "Category", page_len FROM page WHERE page_namespace = "14" ORDER BY page_len DESC LIMIT 1000; SELECT page_title AS "Category talk", page_len FROM page WHERE page_namespace = "15" ORDER BY page_len DESC LIMIT 1000; SELECT page_title AS "Portal", page_len FROM page WHERE page_namespace = "100" ORDER BY page_len DESC LIMIT 1000; SELECT page_title AS "Portal talk", page_len FROM page WHERE page_namespace = "101" ORDER BY page_len DESC LIMIT 1000; SELECT page_title AS "Draft", page_len FROM page WHERE page_namespace = "118" ORDER BY page_len DESC LIMIT 1000; SELECT page_title AS "Draft talk", page_len FROM page WHERE page_namespace = "119" ORDER BY page_len DESC LIMIT 1000; SELECT page_title AS "TimedText", page_len FROM page WHERE page_namespace = "710" ORDER BY page_len DESC LIMIT 1000; SELECT page_title AS "TimedText talk", page_len FROM page WHERE page_namespace = "711" ORDER BY page_len DESC LIMIT 1000; SELECT page_title AS "Module", page_len FROM page WHERE page_namespace = "828" ORDER BY page_len DESC LIMIT 1000; SELECT page_title AS "Module talk", page_len FROM page WHERE page_namespace = "829" ORDER BY page_len DESC LIMIT 1000;
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...