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(links.pl_from)
SELECT CONCAT('* [[User:',revision1.rev_user_text,'|]] [[Special:Diff/',revision1.rev_id,'|removed]] a sitelink from [[Q',epp_entity_id,']] at ',revision1.rev_timestamp,
" with comment: ''",REPLACE(REPLACE(REPLACE(revision1.rev_comment,' */','}}'),'/* wbsetsitelink-remove:','{{int:wikibase-item-summary-wbsetsitelink-remove|'),'}} ','}}: '),"''") AS log,
count(links.pl_from) AS backlinks
	FROM (SELECT rev_id, rev_page, rev_comment, rev_user, rev_user_text, rev_timestamp FROM revision WHERE rev_comment LIKE '/* wbsetsitelink-remove:%') AS revision1
		JOIN (SELECT page_id, page_title FROM page WHERE page_is_redirect = 0 AND page_namespace = 0) AS page1
			ON page1.page_id = revision1.rev_page
		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 (SELECT * FROM pagelinks WHERE pl_from_namespace = 0) AS links
			ON links.pl_title = page1.page_title
	WHERE ips_site_id IS NULL
	AND revision1.rev_user <> 587697
	AND links1.pl_from IS NULL
	AND NOT EXISTS (
		SELECT rev_id, rev_page, rev_comment FROM revision AS revision2
		WHERE revision2.rev_page = revision1.rev_page
		AND revision2.rev_comment LIKE '%sitelink-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 revision1.rev_id
LIMIT 2000;
SQL

Checking query status...
