Test 3 - Quarry

SQL

-- Use ckbwiki_p
use ckbwiki_p;

-- Find articles with Wikidata QIDs in the "زیندووان" category, and check if they talk about deceased individuals
SELECT pp.pp_value AS Qid, page.page_title AS title, wd.claims AS wikidata_claims
FROM page
LEFT JOIN page_props AS pp ON page.page_id = pp.pp_page AND pp.pp_propname = 'wikibase_item'
LEFT JOIN wb_items_per_site AS wd ON pp.pp_value = wd.ips_item_id AND wd.ips_site_id = 'wikidatawiki'
WHERE page_namespace = 0
AND page_is_redirect = 0
AND page.page_id IN (SELECT cl_from FROM categorylinks WHERE cl_to = 'زیندووان')
AND wd.claims.P570 IS NOT NULL;
SQL

Checking query status...
