Wikidata items with removed sitelink(s)

This query lists items with no sitelinks which had some sitelinks before, but they were removed.
It has its testing alternative at https://quarry.wmflabs.org/query/1269

SQL

use wikidatawiki_p;
SELECT CONCAT('* [[User:',rev_user_text,'|]] [[Special:Diff/',rev_id,'|deleted]] a sitelink from [[Q',epp_entity_id,"]] with comment: ''",
REPLACE(REPLACE(REPLACE(rev_comment,' */','}}'),'/* wbsetsitelink-remove:','{{int:wikibase-item-summary-wbsetsitelink-remove|'),"''"),'}} ','}}: '), rev_timestamp
	FROM revision
		JOIN page ON page_id = rev_page
		JOIN wb_entity_per_page ON epp_page_id = page_id
	WHERE rev_comment LIKE '/* wbsetsitelink-remove:%'
	AND NOT EXISTS
		(SELECT *
		 FROM wb_items_per_site
		 WHERE ips_item_id = epp_entity_id
		)
	AND page_is_redirect = 0
GROUP BY page_title
LIMIT 500;

SQL

Checking query status...