Wikidata:Items to be possibly deleted

SQL

USE wikidatawiki_p;
SELECT page_title, page_id, page_latest, claims.pp_value
FROM page
LEFT JOIN pagelinks AS backlinks
	ON backlinks.pl_title = page_title AND backlinks.pl_namespace = page_namespace AND backlinks.pl_from_namespace IN (0,120,146)
JOIN page_props AS sitelinks ON sitelinks.pp_page = page_id
LEFT JOIN pagelinks AS external
	ON external.pl_from = page_id AND external.pl_namespace = 120 AND external.pl_title IN (
      SELECT CONCAT('P', pi_property_id) FROM wb_property_info WHERE pi_type = 'external-id')
JOIN page_props AS claims ON claims.pp_page = page_id AND claims.pp_propname = 'wb-claims'
WHERE page_namespace = 0 AND page_is_redirect = 0
AND sitelinks.pp_propname = 'wb-sitelinks' AND sitelinks.pp_value = 0
AND backlinks.pl_from IS NULL
AND external.pl_title IS NULL
LIMIT 10000;
SQL

Checking query status...
