Test 3 - Quarry

SQL

-- Use ckbwiki_p
USE ckbwiki_p;

-- Find articles in the "زیندووان" category corresponding to 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 IS NOT NULL
AND pp.pp_value IN (SELECT ips_item_id FROM wb_items_per_site WHERE ips_site_id = 'wikidatawiki' AND ips_item_id 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 iwd.entity_id
                   FROM wb_terms AS iwd
                   JOIN wbt_item_terms AS wd ON iwd.entity_type = wd.irt_item_id AND iwd.term_full_entity_id = wd.irt_term_in_lang
                   WHERE wd.irt_item_id = pp.pp_value AND wd.irt_item_id = 'P570');
SQL

Checking query status...
