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

SQL

SELECT DISTINCT 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 IS NULL
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 il_to NOT LIKE '%.svg'))
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 10000;

SQL

Checking query status...