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

SQL

Checking query status...