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 where

log_type = 'patrol' and notauto.log_timestamp>20160601000000 and logging.log_timestamp>20160601000000  group by logging.log_user order by 2 desc, user_id asc