Wikidata items with removed sitelink(s)

SQL

USE wikidatawiki_p;
SELECT CONCAT('* [[User:',rev1.rev_user_text,'|]] [[Special:Diff/',rev1.rev_id,'|removed]] a sitelink from [[',page_title,']] at ',rev1.rev_timestamp,
" with comment: ''",REPLACE(REPLACE(REPLACE(rev1.rev_comment,' */','}}'),'/* wbsetsitelink-remove:','{{int:wikibase-entity-summary-wbsetsitelink-remove|'),'}} ','}}: '),"''") AS log
    FROM (SELECT * FROM page WHERE page_namespace = 0 AND page_is_redirect = 0) AS items
	JOIN (SELECT * FROM page_props WHERE pp_propname = 'wb-sitelinks' AND pp_value = 0) AS props
		ON pp_page = page_id
	JOIN (SELECT * FROM revision WHERE rev_comment LIKE '/* wbsetsitelink-remove:%') AS rev1
		ON rev1.rev_page = page_id
	LEFT JOIN (SELECT * FROM pagelinks WHERE pl_namespace = 0 AND pl_from_namespace = 0) AS links
		ON links.pl_title = page_title
	LEFT JOIN (SELECT * FROM user_groups WHERE ug_group = 'bot') AS bots
		ON ug_user = rev_user
	LEFT JOIN (SELECT * FROM revision WHERE rev_comment LIKE '/* wbsetsitelink-remove:%') AS rev2
    	ON rev2.rev_page = rev1.rev_page AND rev2.rev_id > rev1.rev_id
WHERE rev2.rev_timestamp IS NULL
AND ug_group IS NULL
GROUP BY page_title HAVING COUNT(links.pl_from) = 0
ORDER BY rev1.rev_timestamp;
SQL

Checking query status...
