(iswiki) Categorylinks on redirected cats

SQL

select i.page_title, d.ips_site_page from iswiki_p.page i
join wikidatawiki_p.wb_items_per_site a on a.ips_site_id = "iswiki" and a.ips_site_page = replace(i.page_title, "_", " ")
join wikidatawiki_p.wb_items_per_site b on b.ips_site_id = "enwiki" and a.ips_item_id = b.ips_item_id
join enwiki_p.page e on e.page_title = b.ips_site_page and e.page_namespace = 14
join enwiki_p.categorylinks c on c.cl_from = e.page_id
join wikidatawiki_p.wb_items_per_site f on f.ips_site_id = "enwiki" and f.ips_site_page = replace(c.cl_to, "_", " ")
join wikidatawiki_p.wb_items_per_site d on d.ips_site_id = "iswiki" and d.ips_item_id = f.ips_item_id
where i.page_namespace = 14
and i.page_id not in (
	select v.cl_from from iswiki_p.categorylinks v
)
limit 50
SQL

Checking query status...
