Fork of Articles without images in Tamil Wikipedia by Gnoeee
This query is marked as a draft This query has been published by Gnoeee.

SQL

AخA
 
SELECT 
    p.page_title AS tamil_title, 
    l.ll_title AS english_title,
    IFNULL(ei.image_count, 0) AS image_count
FROM 
    page p 
JOIN 
    langlinks l ON l.ll_from = p.page_id 
    AND l.ll_lang = 'en'
LEFT JOIN 
    (
        SELECT 
            ep.page_id AS english_page_id,
            COUNT(ei.il_to) AS image_count
        FROM 
            page ep
        LEFT JOIN 
            imagelinks ei ON ei.il_from = ep.page_id
        WHERE 
            ep.page_namespace = 0
        GROUP BY 
            ep.page_id
    ) AS ei ON ei.english_page_id = l.ll_from
WHERE 
    p.page_namespace = 0 
    AND p.page_is_redirect = 0 
    AND p.page_len > 100;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...