Test for #1298

SQL

USE wikidatawiki_p;
SELECT rev1.rev_timestamp, rev1.rev_user_text, page_title, rev1.rev_id AS revid, rev1.rev_comment#, COUNT(links.pl_from) AS backlinks_count
    FROM page
	JOIN page_props
		ON pp_page = page_id AND pp_propname = 'wb-sitelinks' AND pp_value = 0
	JOIN revision AS rev1
		ON rev1.rev_page = page_id
	LEFT JOIN pagelinks
		ON links.pl_namespace = page_namespace AND links.pl_title = page_title
	LEFT JOIN user_groups
		ON ug_user = rev_user AND ug_group = 'bot'
	LEFT JOIN revision AS rev2
    	ON rev2.rev_page = rev1.rev_page AND rev2.rev_id > rev1.rev_id AND rev2.rev_comment LIKE '/* wbsetsitelink-remove:%'
WHERE page_namespace = 0
AND page_is_redirect = 0
AND rev_comment LIKE '/* wbsetsitelink-remove:%'
AND 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...
