POTY pages likely vandalized by anonymous users

SQL

USE commonswiki_p;
#SELECT COUNT(*), MIN(img_size), MAX(img_size), AVG(img_size), STDDEV_POP(img_size) FROM image WHERE img_minor_mime='webp';
# 1198 –> "Translations" namespace
SELECT DISTINCT p.page_title FROM page p INNER JOIN revision ON p.page_id=rev_page INNER JOIN ip_changes ON rev_id=ipc_rev_id
	WHERE p.page_namespace=1198 AND p.page_title REGEXP 'Commons:Wiki_Loves_Folklore/(?:[0-1]+|Page_display_title)/(?:id)'
	#AND SELECT COUNT(p1.page_id) AS cnt FROM page AS p1 WHERE p1.page_id=p.page_id
	UNION SELECT COUNT(page_id) FROM page
	ORDER BY p.page_title ASC;

SQL

Checking query status...