Test 3 - Quarry

SQL

-- Use ckbwiki_p
use ckbwiki_p;

-- Find articles in the "زیندووان" category with a Wikidata item
WITH WikidataItems AS (
    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 = 'زیندووان')
)

-- Find deceased individuals on Wikidata
SELECT WikidataItems.title
FROM WikidataItems
JOIN wikidatawiki_p.claims AS claims ON WikidataItems.Qid = claims.claim_entity_id
WHERE claims.claim_property = 'P570'; -- P570 is the property for date of death
SQL

Checking query status...
