People without 570 but with death year category

Fork of People without 569 but with birth year category by Edgars2007

This query is marked as a draft This query has been published by Edgars2007.

SQL

use lvwiki_p;
select wp.page_title, cl_to
from pagelinks pl2
join page wp on wp.page_namespace=0 and wp.page_title=pl_title
join categorylinks on cl_from=wp.page_id and cl_to like "%._gadā_mirušie"
LEFT JOIN page_props AS pp
  ON pp.pp_page = wp.page_id AND pp.pp_propname = 'wikibase_item'
LEFT JOIN wikidatawiki_p.page AS wdp
  ON wdp.page_title = pp.pp_value AND wdp.page_namespace = 0
LEFT JOIN wikidatawiki_p.pagelinks AS wdpl
  ON wdpl.pl_from = wdp.page_id AND wdpl.pl_namespace = 120 AND wdpl.pl_title = 'P570'
where pl2.pl_from=331196 and wdpl.pl_from IS NULL;

SQL

Checking query status...