Untitled query #1276

SQL

use wikidatawiki_p; 
#SELECT * FROM categorylinks LIMIT 5;
#SELECT * FROM page_props WHERE pp_propname = 'wikibase_item' LIMIT 5;
SELECT enwiki_p.pp_value AS Qid, enwiki_p.page_title 
FROM enwiki_p.categorylinks AS encl, enwiki_p.page_props AS enpp, enwiki_p.page As enpt
	LEFT JOIN ( SELECT pl_from FROM pagelinks WHERE pl_title = 'P570' AND pl_namespace = 120 ) As allitemswith570
	ON encl.cl_from = allitemswith570.pl_from WHERE allitemswith570.pl_from IS NULL
AND encl.cl_to = '2015_deaths' 
AND encl.cl_type = 'page'
AND encl.cl_from = enpp.pp_page
AND enpp.pp_propname = 'wikibase_item'
AND encl.cl_from = enpt.page_id
AND enpt.page_title NOT LIKE 'Death%'
AND enpt.page_title NOT LIKE 'List_%'

LIMIT 5
SQL

Checking query status...
