Articles on the Albanian Wikipedia with less than 1000 bytes

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, page_len as 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  -- Group by original fields
order 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...