Edits and logs for FA WP Oversighters

SQL

use fawiki_p;

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)
;

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)

SQL

Checking query status...