Edits and logs for FA WP Oversighters

SQL

use fawiki_p;
select edits.user_name, edits.yearmon, editcount + logcount from
(
select rev_user_text as user_name, left(rev_timestamp, 6) yearmon, count(*) editcount from revision
where rev_user in 
(
2558, -- ظهیری
8483, -- Huji
19510 -- Kamix
)
and rev_timestamp > '20150101000000'
group by rev_user, left(rev_timestamp, 6)
) edits
join
(
select user_name, left(log_timestamp, 6) yearmon, count(*) logcount from logging
join user
on log_user = user_id
where log_user in
(
2558, -- ظهیری
8483, -- Huji
19510 -- Kamix
)
and log_timestamp > '20150101000000'
group by log_user, left(log_timestamp, 6)
) logs
on edits.user_name = logs.user_name
and edits.yearmon = logs.yearmon
SQL

Checking query status...
