Untitled query #19777

SQL

use metawiki_p;
select log_user_text, count(log_type), log_type, YEAR(log_timestamp), MONTH(log_timestamp) 
from logging  
where 
(log_user_text in (select user.user_name from user inner join user_groups 
                   on user_groups.ug_user=user.user_id where user_groups.ug_group='steward'))
and YEAR(log_timestamp)>=2017 
and MONTH(log_timestamp)=1 
and (log_type in ('gblblock','gblrename','gblrights','globalauth','rights','mwoauthconsumer'))
group by log_type, log_user_text,  MONTH(log_timestamp) 
order by MONTH(log_timestamp), log_user_text;
SQL

Checking query status...
