Wikidata items to be possibly deleted

SQL

USE wikidatawiki_p;
SELECT page_title, page_id, page_latest
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 ON pp_page = page_id AND pp_propname = 'wb-sitelinks' AND pp_value = 0
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')
WHERE page_namespace = 0 AND page_is_redirect = 0
AND backlinks.pl_from IS NULL
AND external.pl_title IS NULL
LIMIT 1000;
SQL

Checking query status...
