(iswiki) Category helper

SQL

select i.cl_to, c.cl_to from iswiki_p.categorylinks i
join wikidatawiki_p.wb_items_per_site a on a.ips_site_id = "iswiki" and a.ips_site_page = replace(i.cl_to, "_", " ")
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
where i.cl_to not in (
	select v.page_title from iswiki_p.page v where v.page_namespace = 14
)
limit 25
SQL

Checking query status...
