Deleted Wikidata entities that are still linked

Taken from #1279
See https://www.wikidata.org/wiki/Wikidata:Database_reports/Deleted_Wikidata_entities_that_are_still_linked

SQL

USE wikidatawiki_p;
SELECT * FROM wb_entity_per_page
	JOIN (SELECT * FROM wb_items_per_site WHERE ips_site_id = "cswiki") AS sitelinks
		ON sitelinks.ips_item_id = epp_entity_id
	JOIN (SELECT * FROM pagelinks WHERE pl_title = "Q4167410") AS pagelinks
		ON pagelinks.pl_from = epp_page_id
	JOIN (SELECT * FROM cswiki_p.page WHERE page_namespace = 0) AS page
		ON page.page_title = sitelinks.ips_site_page
	LEFT JOIN (SELECT * FROM cswiki_p.page_props WHERE pp_propname = "disambiguation") AS props
		ON props.pp_page = page.page_id
WHERE pp_propname IS NULL;

SQL

Checking query status...