Articles on sqwiki with less than 1000 bytes

Fork of Pages in NS104 on bnwikisource less than 500 bytes by Mahir256

This query is marked as a draft This query has been published by Klein Muçi.

Articles on sqwiki with less than 1000 bytes

SQL

use sqwiki_p;

select concat("Page:", page_title), page_len
from page
where page_namespace = 0  -- Namespace 0 is for articles
and page_len < 1000  -- Find pages with length less than 1000 bytes
group by page_title, page_len
order by page_len;

​x
 
use sqwiki_p;​select concat("Page:", page_title), page_lenfrom pagewhere page_namespace = 0  -- Namespace 0 is for articlesand page_len < 1000  -- Find pages with length less than 1000 bytesgroup by page_title, page_lenorder by page_len;

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...