Query test 4 - Quarry

SQL

USE wikidatawiki_p;

/*
SELECT page_title
FROM page
WHERE page_namespace = 0
AND page_title NOT IN (
SELECT CONCAT("Q",ips_item_id)
FROM wb_items_per_site 
WHERE ips_site_id='itwiki'
)
AND page_id IN (
SELECT pl_from
	FROM pagelinks
	WHERE pl_namespace = 120
	AND pl_title = 'P1986'
)
*/

SELECT page_title
FROM page
JOIN (SELECT ips_item_id FROM wb_items_per_site WHERE NOT ips_site_id='itwiki') AS nonita_item ON CONCAT("Q",nonita_item.ips_item_id) = page_title
WHERE page_namespace = 0
AND page_id IN (
SELECT pl_from
	FROM pagelinks
	WHERE pl_namespace = 120
	AND pl_title = 'P1986'
);
SQL

Checking query status...
