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 AS searched_item
FROM page
JOIN (SELECT CONCAT("Q",ips_item_id) AS nonita_item FROM wb_items_per_site WHERE NOT ips_site_id='itwiki') ON nonita_item = searched_item
WHERE page_namespace = 0
AND page_id IN (
SELECT pl_from
	FROM pagelinks
	WHERE pl_namespace = 120
	AND pl_title = 'P1986'
)
LIMIT 1;
SQL

Checking query status...
