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 COUNT(p.page_title) FROM page AS p JOIN revision AS r JOIN ip_changes as ipc JOIN page AS p1
	WHERE p.page_namespace=1198 AND p.page_id=r.rev_page AND r.rev_id=ipc.ipc_rev_id AND p.page_id=p1.page_id
		AND p.page_title REGEXP 'Commons:Wiki_Loves_Folklore/(?:[0-1]+|Page_display_title)/(?:id)'
	ORDER BY p.page_title ASC;

SQL

Checking query status...