Query test 4 - Quarry

SQL

USE wikidatawiki_p;

SELECT pl_from
	FROM pagelinks
	WHERE pl_namespace = 120
	AND pl_title = 'P1986'
/*
SELECT CONCAT('* [[Q', ips_item_id, ']]')
FROM wb_items_per_site 
WHERE ips_site_id LIKE '%wiki'
AND NOT ips_site_id='wikidatawiki'
AND NOT ips_site_id='commonswiki'
AND ips_item_id NOT IN
(SELECT ips_item_id
FROM wb_items_per_site
WHERE ips_site_id='itwiki')
AND ips_item_id NOT IN
(SELECT ips_item_id
FROM wb_items_per_site
WHERE ips_site_page LIKE 'Template:%')
AND ips_item_id NOT IN
(SELECT ips_item_id
FROM wb_items_per_site
WHERE ips_site_page LIKE 'Category:%')
AND ips_item_id NOT IN
(SELECT ips_item_id
FROM wb_items_per_site
WHERE ips_site_page LIKE 'Module:%')
AND ips_item_id NOT IN
(SELECT ips_item_id
FROM wb_items_per_site
WHERE ips_site_page LIKE 'Wikimedia:%')
*/
LIMIT 5;
SQL

Checking query status...
