Untranslated redlinks (cswiki)

SQL

USE cswiki_p;
SELECT ref.page_namespace, ref.page_title, pl_title, cs.ips_site_page
FROM pagelinks
LEFT JOIN page AS missing ON missing.page_title = pl_title AND missing.page_namespace = pl_namespace
JOIN wikidatawiki_p.wb_items_per_site AS en ON en.ips_site_id = 'enwiki' AND en.ips_site_page = REPLACE(pl_title, '_', ' ')
JOIN wikidatawiki_p.wb_items_per_site AS cs ON cs.ips_site_id = 'cswiki' AND cs.ips_item_id = en.ips_item_id
JOIN page AS ref ON ref.page_id = pl_from
WHERE missing.page_id IS NULL
AND pl_namespace = 0
AND pl_from_namespace IN (0, 10, 14)
LIMIT 1000;
SQL

Checking query status...
