Longest 1,000 pages in all namespaces

Fork of Longest 1,000 pages in all namespaces by JPxG

This query is marked as a draft This query has been published by Eviolite.

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.

SQL

Checking query status...