Test for #1298

SQL

use wikidatawiki_p;
SELECT page1.page_id, CONCAT("Q",epp_entity_id)# , revision1.rev_id, revision1.rev_timestamp, revision1.rev_user_text #, ips_site_id, COUNT(links.pl_from)
	FROM wb_entity_per_page
		JOIN (SELECT page_id FROM page WHERE page_is_redirect = 0) AS page1
			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 = page1.page_id
#		LEFT JOIN wb_items_per_site
#			ON ips_item_id = epp_entity_id
#		LEFT JOIN (SELECT * FROM pagelinks WHERE pl_namespace = 0 pl_from_namespace = 0) AS links
#			ON links.pl_title = page1.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 page1.page_title
# ORDER BY revision1.rev_id
LIMIT 100;
SQL

Checking query status...
