Voci it.wiki senza interwiki con titolo uguale in en.wiki (no disambigue)

SQL

SELECT page_title
FROM itwiki_p.page
LEFT JOIN itwiki_p.imagelinks ON il_from=page_id
WHERE page_namespace=0
AND page_is_redirect=0
AND il_from NOT LIKE '%.svg'
AND page_id IN
(SELECT ll_from
FROM itwiki_p.langlinks
WHERE ll_title IN (SELECT DISTINCT page_title
FROM enwiki_p.page
LEFT JOIN enwiki_p.imagelinks ON il_from=page_id
WHERE page_namespace=0
AND page_is_redirect=0
AND NOT (il_from IS NULL)))
AND page_id NOT IN
   (SELECT cl_from
    FROM itwiki_p.categorylinks, itwiki_p.pagelinks
    WHERE cl_to = pl_title
    AND pl_namespace = 14
    AND pl_from = 4195411)
LIMIT 10;

SQL

Checking query status...