#/bytes added by ips, users to main/draft recently

SQL

SELECT CASE WHEN rc_namespace = 0 THEN 'Mainspace' ELSE 'Draft' END AS `Namespace`,
       SUM(rc_new_len - COALESCE(rc_old_len, 0)) AS `Bytes added`,
       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)
  AND rc_namespace IN (0, 118)
GROUP BY actor_user IS NULL, rc_namespace;

AخA
 
SELECT CASE WHEN rc_namespace = 0 THEN 'Mainspace' ELSE 'Draft' END AS `Namespace`,       SUM(rc_new_len - COALESCE(rc_old_len, 0)) AS `Bytes added`,       CASE WHEN actor_user IS NULL THEN 'IP' ELSE 'User' END AS `IP/User`FROM recentchangesJOIN actor_recentchanges ON actor_id = rc_actorWHERE rc_new_len > COALESCE(rc_old_len, 0)  AND rc_namespace IN (0, 118)GROUP BY actor_user IS NULL, rc_namespace;

SQL

Checking query status...