Articles where edits are much more likely to be reverted if from IPs

SQL

SELECT rc_namespace, rc_title,
 SUM(CASE WHEN actor_user IS NULL THEN 1 ELSE 0 END) AS ip_total,
 SUM(CASE WHEN actor_user IS NULL AND ct_tag_id IS NOT NULL THEN 1 ELSE 0 END) AS ip_reverted,
 SUM(CASE WHEN actor_user IS NOT NULL THEN 1 ELSE 0 END) AS reg_total,
 SUM(CASE WHEN actor_user IS NOT NULL AND ct_tag_id IS NOT NULL THEN 1 ELSE 0 END) AS reg_reverted
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'
GROUP BY rc_title
HAVING ip_reverted > 10 AND ip_reverted/ip_total * reg_total/(CASE WHEN reg_reverted = 0 THEN 0.0001 ELSE reg_reverted END) > 25
ORDER BY rc_namespace, rc_title

SQL

Checking query status...