Wikidata items with removed sitelink(s)

SQL

use wikidatawiki_p;
SELECT *	# CONCAT('* [[User:',rev_user_text,'|]] [[Special:Diff/',rev_id,'|removed]] a sitelink from [[Q',epp_entity_id,']] at ',rev_timestamp," with comment: ''",
			# REPLACE(REPLACE(REPLACE(rev_comment,' */','}}'),'/* wbsetsitelink-remove:','{{int:wikibase-item-summary-wbsetsitelink-remove|'),'}} ','}}: '),"''") AS log
	FROM revision
		JOIN page ON page_id = rev_page AND page_is_redirect = 0
		JOIN wb_entity_per_page ON epp_page_id = page_id
		LEFT JOIN wb_items_per_site ON ips_item_id = epp_entity_id
	#	LEFT JOIN pagelinks ON pl_title = CONCAT('Q',epp_entity_id) AND pl_from_namespace = 0
	WHERE rev_comment LIKE '/* wbsetsitelink-remove:%'
	AND ips_site_id IS NULL
#	AND pl_from IS NULL
/*	AND NOT EXISTS
		(SELECT *
		 FROM pagelinks
		 WHERE pl_title = CONCAT('Q',epp_entity_id)
		 AND pl_from_namespace = 0) */
GROUP BY page_title
ORDER BY rev_timestamp
LIMIT 2000;
SQL

Checking query status...
