Test 3 - Quarry

SQL

SELECT DISTINCT p.page_title
FROM page AS p
JOIN templatelinks AS tl ON p.page_id = tl.tl_from
LEFT JOIN page_props AS pp ON p.page_id = pp.pp_page
WHERE tl.tl_namespace = 10  -- Check only in the Template namespace
  AND tl.tl_title = 'زیندووان'  -- The category "زیندووان" (Living people)
  AND pp.pp_propname = 'wikibase_item'
  AND EXISTS (
    SELECT 1
    FROM wikidatawiki_p.page AS wd
    WHERE p.page_title = CONCAT('Q', wd.page_title)
      AND wd.page_is_redirect = 0
      AND wd.page_namespace = 0
      AND NOT EXISTS (
        SELECT 1
        FROM wikidatawiki_p.claims AS c
        WHERE wd.page_id = c.claim_entity_id
          AND c.claim_id = 'P570'  -- P570 is the date of death property
        LIMIT 1
      )
  );
SQL

Checking query status...
