Untitled query #1276

SQL

# test
# See also https://upload.wikimedia.org/wikipedia/commons/f/f7/MediaWiki_1.24.1_database_schema.svg


SELECT enpp.pp_value AS Qid
FROM 
	enwiki_p.categorylinks As encl, 
	enwiki_p.page_props AS enpp, 
	wikidatawiki_p.page AS wdpt,
	wikidatawiki_p.pagelinks  
WHERE 
	encl.cl_to = '2015_deaths' 
AND encl.cl_from = enpp.pp_page
AND enpp.pp_propname = 'wikibase_item'
AND encl.cl_type = 'page'
AND enpp.pp_value = wdpt.page_title
AND pl_from = page_id 
AND	pl_title = 'P570'
AND pl_namespace = 120 
AND pl_from_namespace = 0 
#HAVING allitemswith570.page_title IS NULL
LIMIT 3000
SQL

Checking query status...
