Test 3 - Quarry

SQL

USE ckbwiki_p;

SELECT
    CONCAT('# [[', page.page_title, ']]') AS 'Page title'
FROM page
WHERE page_namespace = 0
AND page.page_id IN (SELECT cl_from FROM categorylinks WHERE cl_to = 'زیندووان')
AND page.page_id IN (SELECT cl_from FROM categorylinks WHERE cl_to REGEXP 'مردووانی_')
AND page.page_id IN (SELECT page_id FROM page_props WHERE pp_propname = 'wikibase_item')
AND page.page_id IN (SELECT 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.page_title)))
AND page_is_redirect = 0
ORDER BY page.page_title ASC;
SQL

Checking query status...
