Untitled query #1276

SQL

use enwiki_p; 
#SELECT * FROM categorylinks LIMIT 5;
#SELECT * FROM page_props WHERE pp_propname = 'wikibase_item' LIMIT 5;
SELECT enpp.pp_value AS Qid, enpt.page_title
FROM categorylinks, page_props AS enpp, page As enpt
	LEFT JOIN ( SELECT pl_from FROM wikidatawiki_p.pagelinks 
               WHERE pl_title = 'P570' AND pl_namespace = 120 ) As allitemswith570
	ON categorylinks.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...
