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.