Test for #1298

SQL

use wikidatawiki_p;
SELECT page_id, CONCAT("Q",epp.epp_entity_id), revision1.rev_id, revision1.rev_timestamp, revision1.rev_user_text #, ips_site_id, COUNT(links.pl_from)
	FROM (SELECT * FROM wb_entity_per_page WHERE epp_redirect_target IS NULL) AS epp
		JOIN page
			ON page_id = epp.epp_page_id
#		JOIN (SELECT rev_page, rev_id, rev_timestamp, rev_user, rev_user_text, rev_comment FROM revision WHERE rev_comment LIKE '/* wbsetsitelink-remove:%') AS revision1
#			ON revision1.rev_page = page_id
#		LEFT JOIN wb_items_per_site
#			ON ips_item_id = epp.epp_entity_id
#		LEFT JOIN (SELECT * FROM pagelinks WHERE pl_from_namespace = 0) AS links
#			ON links.pl_title = page_title
#	WHERE ips_site_id IS NULL
#	AND links.pl_from IS NULL
#	AND revision1.rev_user <> 587697
/*	AND NOT EXISTS (
		SELECT rev_id, rev_page, rev_comment
			FROM revision AS revision2
            WHERE revision2.rev_page = revision1.rev_page
            AND revision2.rev_comment LIKE '%sitelink-remove:%'
            AND revision2.rev_id > revision1.rev_id) */
GROUP BY page_title
ORDER BY revision1.rev_id
LIMIT 2000;
SQL

Checking query status...
