Untitled query #91472

SQL

USE enwiki_p;

SELECT page.page_id, page.page_title, page.page_len
FROM page
LEFT JOIN langlinks 
ON page.page_id = langlinks.ll_from 
AND langlinks.ll_lang = 'te'
JOIN categorylinks 
ON page.page_id = categorylinks.cl_from
WHERE page.page_namespace = 0  -- Main namespace (articles)
AND langlinks.ll_from IS NULL  -- Articles that do NOT have a Telugu version
AND page.page_len >= 9000  -- Articles with at least 9000 bytes in size
AND categorylinks.cl_to LIKE 'Indian_women%'  -- Articles related to Indian women
ORDER BY page.page_len DESC  -- Sort by size (largest first)
LIMIT 1000;
SQL

Checking query status...
