Test 3 - Quarry

SQL

USE ckbwiki_p;

SELECT DISTINCT CONCAT('# [[', page.page_title, ']]') AS 'Page title'
FROM page
JOIN categorylinks ON page.page_id = categorylinks.cl_from
LEFT JOIN page_props ON page.page_id = page_props.pp_page AND page_props.pp_propname = 'wikibase_item'
LEFT JOIN wb_items_per_site ON page.page_title = wb_items_per_site.ips_site_page AND wb_items_per_site.ips_site_id = 'wikidatawiki'
WHERE page_namespace = 0
AND categorylinks.cl_to = 'زیندووان'
AND page.page_id IN (SELECT cl_from FROM categorylinks WHERE cl_to REGEXP 'مردووانی_')
AND page_is_redirect = 0
AND pp.pp_value IS NOT NULL
ORDER BY page.page_title ASC;
SQL

Checking query status...
