Articles on the Albanian Wikipedia with less than 1000 bytes

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

​x
 
use sqwiki_p; -- Use the Albanian Wikipedia​select replace(page_title, '_', ' ') as Articles, page_len as Length -- Replace underscores in titles with spacesfrom pagewhere page_namespace = 0  -- Namespace 0 is for articlesand page_len < 200  -- Find pages with length less than 1000 bytesand page_is_redirect = 0  -- Exclude redirectsgroup by page_title, page_len  -- Group by original fieldsorder by page_len; -- Order by page length​

SQL

Checking query status...