nowiki pages containing manual interwikilinks to enwiki

SQL

SELECT page_title as article, ll_lang, ll_title as ceb_IW, pp_value as WD_item
FROM langlinks 
JOIN page ON page_id = ll_from and ll_lang = "ceb"
	LEFT JOIN (SELECT * FROM page_props WHERE pp_propname = 'wikibase_item') AS props
		ON pp_page = page_id
join categorylinks on page_id=cl_from
WHERE page_namespace = 0 and page_is_redirect = 0
and pp_value is not NULL 
and cl_to like "Robotskapade_artiklar%"
and REPLACE(page_title, "_", " ") in (SELECT w1.ips_site_page 
                                       FROM wikidatawiki_p.wb_items_per_site w1 WHERE w1.ips_site_id = "nowiki" 
     and w1.ips_item_id not in (select w2.ips_item_id from wikidatawiki_p.wb_items_per_site w2 where w2.ips_site_id = "cebwiki"))
group by page_id

SQL

Checking query status...