SQL
AخA
SELECT SUM(rc_new_len - COALESCE(rc_old_len, 0)),
CASE WHEN actor_user IS NULL THEN 'IP' ELSE 'User' END AS `IP/User`
FROM recentchanges
JOIN actor_recentchanges ON actor_id = rc_actor
WHERE rc_new_len > COALESCE(rc_old_len, 0)
GROUP BY actor_user IS NULL;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.