Test for #1298

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)
	FROM wb_entity_per_page
		JOIN revision
			ON rev_comment LIKE '/* wbsetsitelink-remove:%' AND rev_page = epp_page_id AND NOT rev_user = 587697
		LEFT JOIN wb_items_per_site
			ON ips_item_id = epp_entity_id
		LEFT JOIN (SELECT * FROM pagelinks WHERE pl_namespace = 0 AND pl_from_namespace = 0) AS links
			ON links.pl_title = CONCAT("Q",epp_entity_id)
	WHERE ips_site_id IS NULL
	AND epp_redirect_target IS NULL
	AND NOT EXISTS (
		SELECT rev_id, rev_page, rev_comment
			FROM revision AS revision2
            WHERE revision2.rev_page = rev_page
            AND revision2.rev_comment LIKE '%sitelink-remove:%'
            AND revision2.rev_id > rev_id)
GROUP BY epp_entity_id HAVING COUNT(links.pl_from) = 0
ORDER BY rev_id;
SQL

Checking query status...
