Test 3 - Quarry

SQL

-- Use ckbwiki_p
use ckbwiki_p;

-- Find articles in "زیندووان" category that are about deceased people based on Wikidata P570
SELECT
  pp.pp_value AS Qid,
  page.page_title AS title
FROM page
LEFT JOIN page_props AS pp ON page.page_id = pp.pp_page AND pp.pp_propname = 'wikibase_item'
WHERE
  page_namespace = 0
  AND page_is_redirect = 0
  AND page.page_id IN (SELECT cl_from FROM categorylinks WHERE cl_to = 'زیندووان')
  AND pp.pp_value IN (SELECT ips_item_id FROM wb_items_per_site WHERE ips_site_id = 'wikidatawiki' AND ips_site_page = CONCAT('Q', page.page_title))
  AND pp.pp_value IN (SELECT DISTINCT entity_id AS wikidata_id FROM wb_terms WHERE term_full_entity_id = CONCAT('Q', page.page_title))
  AND pp.pp_value IN (SELECT DISTINCT wd_id FROM wb_entity_per_page WHERE wd_id = pp.pp_value AND wd_content_model = 'wikibase-item' AND wd_page_id = page.page_id)
  AND pp.pp_value IN (SELECT entity_id FROM wb_content_in_other_languages WHERE entity_id = pp.pp_value);
SQL

Checking query status...
