Test 3 - Quarry

SQL

SELECT DISTINCT page_title
FROM categorylinks
JOIN page ON cl_from = page_id
JOIN page_props ON page_id = pp_page
WHERE cl_to = 'زیندووان'
AND pp_propname = 'wikibase_item'
AND page_title NOT IN (
  SELECT DISTINCT page_title
  FROM categorylinks
  JOIN page ON cl_from = page_id
  JOIN page_props ON page_id = pp_page
  WHERE cl_to = 'زیندووان'
  AND pp_propname = 'wikibase_item'
  AND page_id IN (
    SELECT DISTINCT page_id
    FROM page_props
    WHERE pp_value IN (
      SELECT DISTINCT item_id
      FROM wbclaims
      WHERE claim_id IN (
        SELECT DISTINCT claim_id
        FROM wbclaims
        WHERE snaktype = 'value'
        AND property = 'P31'
        AND value IN ('Q5', 'Q937857')
      )
      AND property = 'P570'
    )
  )
);
SQL

Checking query status...
