Articles without images in Tamil Wikipedia

Fork of Articles without images in Tamil Wikipedia by Gnoeee

This query is marked as a draft This query has been published by Gnoeee.

Articles without images in Tamil Wikipedia

SQL

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.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...