Untitled query #10861

SQL

USE fawiki_p;
select user_name, ifnull(notauto.cnt, 0) noauto from logging join user on user_id = log_user left join 
(select log_user,log_timestamp, 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 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 2 desc, user_id asc
SQL

Checking query status...
