Test for #1298

SQL

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