Untitled query #1276

SQL


SELECT enpp.pp_value AS Qid
FROM (enwiki_p.categorylinks As encl, enwiki_p.page_props AS enpp)
	LEFT JOIN ( SELECT page_title FROM wikidatawiki_p.pagelinks,  wikidatawiki_p.page 
				WHERE 	pl_title = 'P570' AND pl_namespace = 120 
               			AND pl_from_namespace = 0 AND pl_from = page_id ) As allitemswith570
	ON enpp.pp_value = allitemswith570.page_title
	WHERE allitemswith570.page_title IS NULL

AND encl.cl_to = '2015_deaths' 
AND encl.cl_from = enpp.pp_page
AND enpp.pp_propname = 'wikibase_item'
AND encl.cl_type = 'page'

LIMIT 3000
SQL

Checking query status...
