wikidata: deleted wikidata entities that are still linked

SQL

USE wikidatawiki_p;

# from https://www.wikidata.org/wiki/Wikidata:Database_reports/Deleted_Wikidata_entities_that_are_still_linked/Configuration
# mind that this is not the most recent version of the script

SELECT
	pagelinks.pl_title,
    COUNT(*)
FROM
	pagelinks LEFT JOIN page ON
    	pagelinks.pl_title=page.page_title
        AND pagelinks.pl_namespace=page.page_namespace
WHERE
	pagelinks.pl_from_namespace IN (0, 120, 146)
    AND pagelinks.pl_namespace IN (0, 120, 146)
    AND page.page_id IS NULL
GROUP BY
	pagelinks.pl_title;
    
ORDE BY
	,
,

SQL

Checking query status...