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  -- Join with the categorylinks table
AND cl.cl_to = 'Faqe_për_grisje'  -- Specify the category to exclude ('Kategoria:' prefix is omitted)
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 the 'Faqe për grisje' category
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  -- Join with the categorylinks tableAND cl.cl_to = 'Faqe_për_grisje'  -- Specify the category to exclude ('Kategoria:' prefix is omitted)WHERE 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 the 'Faqe për grisje' categoryGROUP 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...