use fawiki_p;

select concat('[[user:',user_name,']]'), log_type, count(log_id)

from user

join logging

on log_user = user_id

where log_type in ('delete', 'block', 'protect','abusefilter','merge') and

log_timestamp>20160601000000 and not (user_name like '%bot' or user_name like '%Bot' or user_name like 'پالایه%')

group by log_user, log_type order by 2,3 desc;