Wikidata items with removed sitelink(s)

SQL

use wikidatawiki_p;
# SELECT page1.page_id, CONCAT("Q",epp_entity_id), rev_id, rev_timestamp, rev_user_text, ips_site_id # , COUNT(pl_from)
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 AS revision1
		JOIN (SELECT page_id, page_title FROM page WHERE page_is_redirect = 0) AS page1 ON page1.page_id = revision1.rev_page
		JOIN wb_entity_per_page ON epp_page_id = page_id # AND epp_redirect_target IS NULL
		LEFT JOIN wb_items_per_site ON ips_item_id = epp_entity_id
#		LEFT JOIN (SELECT * FROM pagelinks WHERE pl_from_namespace = 0) AS pl1 ON pl1.pl_title = page1.page_title # AND pl1.pl_from IS NULL
	WHERE revision1.rev_comment LIKE '/* wbsetsitelink-remove:%'
	AND ips_site_id IS NULL
	AND rev_user <> 587697
#	AND pl1.pl_from IS NULL
	AND NOT EXISTS (
		SELECT * FROM revision AS revision2
		WHERE revision2.rev_page = revision1.rev_page
		AND revision2.rev_comment LIKE '/* wbsetsitelink-remove:%'
		AND revision2.rev_id > revision1.rev_id)
/*	AND NOT EXISTS (
		SELECT * FROM pagelinks
		WHERE pl_title = page1.page_title
		AND pl_from_namespace = 0) */
GROUP BY page1.page_title
ORDER BY rev_id
LIMIT 2000;
SQL

Checking query status...
