Articles with recent reverted edits from many IPs

SQL

SELECT rc_namespace, rc_title,
 COUNT(DISTINCT actor_name) AS addresses,
 COUNT(DISTINCT CASE WHEN ct_tag_id IS NULL THEN NULL ELSE actor_name END) AS rv_addresses,
 COUNT(DISTINCT actor_name) / COUNT(DISTINCT CASE WHEN ct_tag_id IS NULL THEN NULL ELSE actor_name END) AS rv_addresses_pc,
 COUNT(*) AS ip_edits,
 SUM(ct_tag_id IS NOT NULL) AS rv_ip_edits,
 COUNT(*) / SUM(ct_tag_id IS NOT NULL) AS rv_ip_edits_pc
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 '20230204' AND '20230205' AND actor_user IS NULL /* IP edits only */
AND NOT EXISTS (SELECT 1 FROM page_restrictions WHERE pr_page = rc_cur_id)
GROUP BY rc_namespace, rc_title
HAVING rv_addresses >= 5 AND ip_edits <= rv_ip_edits * 2
ORDER BY rc_namespace, rc_title
SQL

Checking query status...
