Test for #1298

SQL

USE wikidatawiki_p;
SELECT rev_timestamp, rev_user_text, CONCAT('Q',epp_entity_id) AS Qid, CONCAT('[[Special:Diff/',rev_id,']]') AS revid, rev_comment, COUNT(links.pl_from) AS backlinks_count
	FROM wb_entity_per_page
	JOIN (SELECT * FROM revision WHERE rev_comment LIKE '/* wbsetsitelink-remove:%') AS rev1
		ON rev1.rev_page = epp_page_id
	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)
	LEFT JOIN user_groups
		ON ug_user = rev_user
WHERE ips_site_id IS NULL
AND epp_redirect_target IS NULL
AND (ug_group IS NULL OR NOT ug_group = "bot")
AND NOT EXISTS (
	SELECT rev_id, rev_page
		FROM revision AS rev2
		WHERE rev2.rev_page = rev1.rev_page
		AND rev2.rev_comment LIKE '/* wbsetsitelink-remove:%'
		AND rev2.rev_timestamp > rev1.rev_timestamp
    )
GROUP BY epp_entity_id # HAVING COUNT(links.pl_from) = 0
ORDER BY rev_timestamp;
SQL

Checking query status...
