select count(rc_id) as edits, floor(count(rc_id)/28) as edits_per_day, actor_name , user_editcount

from recentchanges_userindex

left join actor on rc_actor = actor_id

left join user  on actor_user = user_id

where (rc_timestamp >= DATE_ADD(NOW(), INTERVAL -28 DAY) )

      and (rc_bot = 0) and (rc_type < 5)

      and actor_name IN ('LilHelpa', 'Headbomb', 'Aboutmovies', "R'n'B", '', 'Starcheerspeaksnewslostwars', 'Niceguyedc', 'EP111', 'Lord Cornwallis', 'KylieTastic')

group by rc_actor order by user_editcount desc;

​

select count(rc_id)/280 as avg_edits_per_day

from recentchanges_userindex

left join actor on rc_actor = actor_id

where (rc_timestamp >= DATE_ADD(NOW(), INTERVAL -28 DAY) )

      and (rc_bot = 0) and (rc_type < 5)

      and actor_name IN ('LilHelpa', 'Headbomb', 'Aboutmovies', "R'n'B", '', 'Starcheerspeaksnewslostwars', 'Niceguyedc', 'EP111', 'Lord Cornwallis', 'KylieTastic')

;

​

select count(rc_id) as edits, floor(count(rc_id)/28) as edits_per_day, actor_name, user_editcount

from recentchanges_userindex

left join actor on rc_actor = actor_id

left join user  on actor_user = user_id

where (rc_timestamp >= DATE_ADD(NOW(), INTERVAL -28 DAY) )

      and (rc_bot = 0) and (rc_type < 5)

      and actor_name IN ('KylieTastic', 'William Avery', 'TonyTheTiger', 'Dormskirk', 'Discospinster', 'CAPTAIN RAJU', 'Mandarax', 'Shellwood', 'Flyer22 Frozen', 'Geregen2')

group by rc_actor order by user_editcount desc;

​

​

select count(rc_id)/280 as avg_edits_per_day

from recentchanges_userindex

left join actor on rc_actor = actor_id

where (rc_timestamp >= DATE_ADD(NOW(), INTERVAL -28 DAY) )

      and (rc_bot = 0) and (rc_type < 5)

      and actor_name IN ('KylieTastic', 'William Avery', 'TonyTheTiger', 'Dormskirk', 'Discospinster', 'CAPTAIN RAJU', 'Mandarax', 'Shellwood', 'Flyer22 Frozen', 'Geregen2')

;