کاربران گشت‌زده در یک ماه اخیر

SQL

USE fawiki_p;
select user_name, ifnull(auto.cnt, 0) auto, ifnull(notauto.cnt, 0) noauto, count(log_id) tot from logging join user on user_id = log_user left join 
(select *, count(log_id) cnt from logging where log_type = 'patrol' and log_params like '%auto";i:1%' or log_params like '%1' group by log_user) 
auto on logging.log_user = auto.log_user left join (select *, count(log_id) cnt from logging where 
log_type = 'patrol' and log_params like '%auto";i:0%' or log_params like '%0' group by log_user) 
notauto on logging.log_user = notauto.log_user left join user_groups on user_id = ug_user and ug_group = 'bot' where
log_type = 'patrol' and notauto.log_timestamp>20160601000000 and logging.log_timestamp>20160601000000 and ug_group is null group by logging.log_user order by tot desc, user_id asc
SQL

Checking query status...
