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.

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

SQL

Checking query status...