Untranslated redlinks (cswiki)

SQL

USE cswiki_p;
SELECT ref.page_title, pl_title 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 = 0
LIMIT 1;

SQL

Checking query status...