Untitled query #91475

SQL

USE enwiki_p;

SELECT DISTINCT page.page_id, page.page_title, page.page_len
FROM page
JOIN categorylinks ON page.page_id = categorylinks.cl_from
LEFT JOIN langlinks ON page.page_id = langlinks.ll_from AND langlinks.ll_lang = 'te' -- Check Telugu version
WHERE page.page_namespace = 0 -- Only articles
AND page.page_is_redirect = 0 -- Exclude redirects
AND categorylinks.cl_to = '21st-century_Indian_women' -- Filter only Indian women film producers
-- Ensure the article has at least 5000 bytes
AND langlinks.ll_from IS NULL -- Ensure there is NO Telugu version
LIMIT 500;
SQL

Checking query status...
