Test 3 - Quarry

SQL

# Use the ckbwiki_p database
use ckbwiki_p;

# Retrieve articles with Wikidata QIDs
SELECT pp.pp_value as Qid, page_title as title
FROM page
LEFT JOIN page_props as pp ON page_id = pp.pp_page AND pp.pp_propname = 'wikibase_item'
WHERE page_namespace = 0
AND page_is_redirect = 0
AND page_title IN (
    SELECT DISTINCT cl_from
    FROM categorylinks
    WHERE cl_to = 'زیندووان'
    AND cl_from IN (
        SELECT DISTINCT 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_title)
        )
    )
);
SQL

Checking query status...
