Articles with recent reverted edits from many IPs

SQL

SELECT rc_namespace AS ns, rc_title AS title,
 COUNT(DISTINCT actor_name) AS IPs,
 COUNT(DISTINCT CASE WHEN ct_tag_id IS NULL THEN NULL ELSE actor_name END) AS rv_IPs,
 COUNT(DISTINCT CASE WHEN ct_tag_id IS NULL THEN NULL ELSE actor_name END) / COUNT(DISTINCT actor_name) * 100 AS rv_IPs_pc,
 COUNT(*) AS edits,
 SUM(ct_tag_id IS NOT NULL) AS rv_edits,
 SUM(ct_tag_id IS NOT NULL) / COUNT(*) * 100 AS rv_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 REPLACE(CURDATE() - INTERVAL 2 DAY,"-","") AND REPLACE(CURDATE(),"-","") AND actor_user IS NULL /* IP edits only */
AND NOT EXISTS (SELECT 1 FROM page_restrictions WHERE pr_page = rc_cur_id)
GROUP BY ns, title
HAVING rv_IPs >= 5 AND edits <= rv_edits * 2
ORDER BY ns, title
SQL

Checking query status...
