Articles with recent reverted edits from many IPs

Pages where most IP edits have been reverted, and at least five different IPs have been reverted, over the previous two days

SQL

SELECT rc_namespace, rc_title,
 COUNT(DISTINCT CASE WHEN ct_tag_id IS NULL THEN NULL ELSE actor_name END) AS reverted_ip_addresses,
 COUNT(DISTINCT actor_name) AS ip_addresses,
 COUNT(*) AS ip_edits,
 SUM(ct_tag_id IS NOT NULL) AS reverted_ip_edits,
FROM recentchanges
JOIN actor ON actor_id = rc_actor
LEFT JOIN change_tag ON ct_rc_id = rc_id AND ct_tag_id = 590 /* mw-reverted */
WHERE rc_timestamp BETWEEN '20230128' AND '20230204' AND actor_user IS NULL /* IP edits only */
GROUP BY rc_namespace, rc_title
HAVING distinct_reverted_ips > 5
ORDER BY rc_namespace, rc_title

SQL

Checking query status...