Untitled query #88538

SQL

USE tawiki_p;

SELECT 
    p1.page_title AS ta_page_title,
    p2.page_title AS en_page_title
FROM 
    page AS p1
JOIN 
    langlinks AS ll
    ON p1.page_id = ll.ll_from
JOIN 
    enwiki_p.page AS p2
    ON ll.ll_title = p2.page_title AND ll.ll_lang = 'en'
LEFT JOIN 
    tawiki_p.imagelinks AS il
    ON p1.page_id = il.il_from
WHERE 
    p1.page_namespace = 0 -- Only articles in the main namespace
    AND p1.page_is_redirect = 0 -- Exclude redirects
    AND il.il_from IS NULL -- Articles without images
    AND p2.page_namespace = 0 -- English article in the main namespace
    AND p2.page_id IN (
        SELECT DISTINCT il_from
        FROM enwiki_p.imagelinks
    ) -- English article has images
LIMIT 100; -- Adjust limit as needed
SQL

Checking query status...
