Untitled query #91440

SQL

USE enwiki_p;

SELECT DISTINCT page.page_id, page.page_title, page.page_len
FROM page
JOIN categorylinks c1 ON page.page_id = c1.cl_from
JOIN categorylinks c2 ON page.page_id = c2.cl_from
LEFT JOIN langlinks ON page.page_id = langlinks.ll_from AND langlinks.ll_lang = 'te' -- Check for Telugu version
WHERE page.page_namespace = 0 -- Only articles
AND page.page_is_redirect = 0 -- Exclude redirects
AND c1.cl_to IN ('Indian_film_actresses', 'Indian_stage_actresses', 'Indian_television_actresses') -- Indian actresses in films, stage, and TV
AND c2.cl_to IN ('18th-century_Indian_actresses', '19th-century_Indian_actresses', '20th-century_Indian_actresses', '21st-century_Indian_actresses') -- Filter by centuries
AND page.page_len > 9000 -- Ensure the article has at least 5000 bytes
AND langlinks.ll_from IS NULL -- Ensure there is NO Telugu version
LIMIT 100;
SQL

Checking query status...
