Articles on the Albanian Wikipedia with less than 1000 bytes

Fork of Articles on the Albanian Wikipedia with less than 1000 bytes by Klein Muçi

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

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

SQL

use sqwiki_p; -- Use the Albanian Wikipedia

select replace(page_title, '_', ' ') as Articles, page_len as Length -- Replace underscores in titles with spaces
from page
where page_namespace = 0  -- Namespace 0 is for articles
and page_len < 500  -- Find pages with length less than 1000 bytes
and page_is_redirect = 0  -- Exclude redirects
group by page_title, page_len  -- Group by original fields
order by page_len; -- Order by page length

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