Articles on the Albanian Wikipedia with less than 1000 bytes - Quarry

Fork of Articles on sqwiki with less than 1000 bytes by Klein Muçi

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

List articles on the Albanian Wikipedia with less than 1000 bytes of content in them

SQL

use sqwiki_p;

select replace(page_title, '_', ' ') as Articles, Length
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 replace(page_title, '_', ' ') as Articles, Lengthfrom 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.

Checking query status...