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' -- Exclude Telugu Wikipedia articles

WHERE page.page_namespace = 0 -- Only main articles

AND page.page_is_redirect = 0 -- Exclude redirects

AND categorylinks.cl_to = 'American_female_middle-distance_runners' -- Category for Mexican TV actresses

AND page.page_len > 9000 

AND langlinks.ll_from IS NULL -- Ensure no Telugu version exists

LIMIT 100;

​