Bytes changed per user - Last 30 days

Fork of AfC daily review stats (review, accept, decline) by KylieTastic

This query is marked as a draft This query has been published by KylieTastic.

SQL

select * from (
select actor_name, sum(rc_new_len - rc_old_len) as total_change, sum( abs(rc_new_len - rc_old_len) ) as abs_change  
	  from recentchanges_userindex
	  left join actor_recentchanges on rc_actor = actor_id
	 where (rc_bot = 0) and (rc_source = 'mw.new' or rc_source='mw.edit')
  group by actor_name
) subres
where abs_change > 100000
ORDER by abs_change DESC;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...