SQL
AخA
use arwiki_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>20160101000000 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;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.