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;  -- Use the Albanian Wikipedia

SELECT REPLACE(p.page_title, '_', ' ') AS Articles, p.page_len AS Length -- Replace underscores in titles with spaces
FROM page p
LEFT JOIN categorylinks cl ON p.page_id = cl.cl_from 
AND cl.cl_to IN ('Faqe_për_grisje', 'Faqe_kthjelluese')  -- Specify both categories to exclude
WHERE p.page_namespace = 0  -- Namespace 0 is for articles
AND p.page_len < 1024  -- Find pages with length less than 1KB
AND p.page_is_redirect = 0  -- Exclude redirects
AND cl.cl_to IS NULL  -- Exclude pages that are in 'Faqe për grisje' or 'Faqe kthjelluese'
GROUP BY p.page_title, p.page_len  -- Group by original fields
ORDER BY p.page_len;  -- Order by page length

​x
 
USE sqwiki_p;  -- Use the Albanian Wikipedia​SELECT REPLACE(p.page_title, '_', ' ') AS Articles, p.page_len AS Length -- Replace underscores in titles with spacesFROM page pLEFT JOIN categorylinks cl ON p.page_id = cl.cl_from AND cl.cl_to IN ('Faqe_për_grisje', 'Faqe_kthjelluese')  -- Specify both categories to excludeWHERE p.page_namespace = 0  -- Namespace 0 is for articlesAND p.page_len < 1024  -- Find pages with length less than 1KBAND p.page_is_redirect = 0  -- Exclude redirectsAND cl.cl_to IS NULL  -- Exclude pages that are in 'Faqe për grisje' or 'Faqe kthjelluese'GROUP BY p.page_title, p.page_len  -- Group by original fieldsORDER BY p.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...