Articles without images on itwiki

SQL

use itwiki_p;
SELECT page_title
FROM page
LEFT JOIN imagelinks ON il_from=page_id
WHERE page_namespace=0
AND page_is_redirect=0
AND il_from IS NULL
AND page_id IN
(SELECT ll_from
FROM langlinks
WHERE ll_lang = "en"
AND ll_title IN (
SELECT enwiki_p.page_title
FROM enwiki_p.page
LEFT JOIN enwiki_p.imagelinks ON enwiki_p.il_from=enwiki_p.page_id
WHERE enwiki_p.page_namespace=0
AND enwiki_p.page_is_redirect=0
AND NOT (enwiki_p.il_from IS NULL)))
AND page_id NOT IN
   (SELECT cl_from
    FROM categorylinks, pagelinks
    WHERE cl_to = pl_title
    AND pl_namespace = 14
    AND pl_from = 4195411) /* Wikipedia:ConnectivityProjectInternationalization/ArticlesNotFormingValidLinks */
LIMIT 100;
SQL

Checking query status...
