Edits and logs for FA WP Oversighters

SQL

use fawiki_p;
select edits.user_name, editcount, logcount from
(
select rev_user_text as user_name, /*left(rev_timestamp, 6),*/ 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, count(*) logcount from logging
join user
on log_user = user_id
where log_user in
(
2558, -- ظهیری
8483, -- Huji
19510 -- Kamix
)
group by log_user
) logs
on edits.user_name = logs.user_name

SQL

Checking query status...