Fa WP user edit/log counts in the last three years

SQL

use fawiki_p;
select rev_user, user_name, u.ug_group, count(rev_timestamp) editcount, l.logcount
from revision
join user
on rev_user = user_id
left join
(
  select ug_user, ug_group
  from user_groups
  where ug_group = 'sysop'
) u
on u.ug_user = user_id
left join
(
select log_user, count(log_id) as logcount
from logging
where log_timestamp > '20120603000000'
group by log_user
) l
on l.log_user = rev_user
where rev_timestamp > '20120603000000'
and rev_user not in
(
  select ug_user
  from user_groups
  where ug_group = 'bot'
)
group by rev_user , user_name, u.ug_group
;

SQL

Checking query status...