Deleted Wikidata entities that are still linked

SQL

SELECT page.page_title, items.page_title
	FROM (SELECT * FROM cswiki_p.page_props WHERE pp_propname = "wikibase-item") AS connected
	LEFT JOIN (SELECT * FROM cswiki_p.page_props WHERE pp_propname = "disambiguation") AS non_disambigs
		ON non_disambigs.pp_page = connected.pp_page
	JOIN (SELECT * FROM cswiki_p.page WHERE page_namespace = 0 AND page_is_redirect = 0) AS pages
		ON pages.page_id = connected.page_id
	JOIN (SELECT * FROM wikidatawiki_p.page WHERE page_namespace = 0) AS items
		ON items.page_title = connected.pp_value
	JOIN (SELECT * FROM pagelinks WHERE pl_title = "Q4167410" AND pl_namespace = 0) AS pagelinks
		ON pagelinks.pl_from = items.page_id
WHERE non_disambigs.pp_propname IS NULL;
SQL

Checking query status...
