Untitled query #92811

SQL

SELECT
  a.actor_name,
  SUM(COALESCE(r.rev_len, 0) - COALESCE(r_prev.rev_len, 0)) AS total_bytes_change,
  SUM(CASE WHEN p.page_namespace = 0 THEN COALESCE(r.rev_len, 0) - COALESCE(r_prev.rev_len, 0) ELSE 0 END) AS Article,
  SUM(CASE WHEN p.page_namespace = 1 THEN COALESCE(r.rev_len, 0) - COALESCE(r_prev.rev_len, 0) ELSE 0 END) AS Talk,
  SUM(CASE WHEN p.page_namespace = 4 THEN COALESCE(r.rev_len, 0) - COALESCE(r_prev.rev_len, 0) ELSE 0 END) AS Wiki,
  SUM(CASE WHEN p.page_namespace = 5 THEN COALESCE(r.rev_len, 0) - COALESCE(r_prev.rev_len, 0) ELSE 0 END) AS TalkWiki,
  SUM(CASE WHEN p.page_namespace = 10 THEN COALESCE(r.rev_len, 0) - COALESCE(r_prev.rev_len, 0) ELSE 0 END) AS Temp,
  SUM(CASE WHEN p.page_namespace = 14 THEN COALESCE(r.rev_len, 0) - COALESCE(r_prev.rev_len, 0) ELSE 0 END) AS Cat

FROM revision r
JOIN revision r_prev ON r.rev_parent_id = r_prev.rev_id
JOIN actor a ON r.rev_actor = a.actor_id
JOIN page p ON r.rev_page = p.page_id

WHERE  a.actor_name NOT LIKE '%bot%'      
  AND a.actor_name NOT LIKE '%Bot%'
  AND a.actor_name NOT LIKE '%MediaWiki%'

GROUP BY a.actor_id
ORDER BY total_bytes_change DESC
LIMIT 100;
SQL

Checking query status...
