Eliminator actions that may be against the policy

SQL

use fawiki_p;
select distinct log_id, user_name,
log_title as link,
log_comment, log_timestamp,
str_to_date(left(log_timestamp, 8), '%Y%m%d'),
'محافظت بیش از یک هفته' as issue
from logging
join user_groups on log_user = ug_user
join user on log_user = user_id
where ug_group = 'eliminator'
and log_type = 'protect'
and log_action = 'protect'
and (
  log_params like '%[edit=autoconfirmed]%' or log_params not like '%[create=autoconfirmed]%'
)
-- and log_timestamp >= date_format(date_sub(now(), interval 30 day), '%Y%m%d000000')
/*
select distinct log_id, user_name,
CONCAT('{{ns:', ar_namespace, '}}:', ar_title) as link,
log_comment,
str_to_date(left(log_timestamp, 8), '%Y%m%d'),
'حذف تصویر' as issue
from logging
join user_groups on log_user = ug_user
join user on log_user = user_id
join archive on log_page = ar_page_id
where ug_group = 'eliminator'
and log_type = 'delete'
and ar_namespace = 6
and log_timestamp >= date_format(date_sub(now(), interval 30 day), '%Y%m%d000000')
union
select distinct log_id, u.user_name,
CONCAT('کاربر:', log_title) as link,
log_comment,
str_to_date(left(log_timestamp, 8), '%Y%m%d'),
'بستن غیرمجاز' as issue
from logging
join user_groups ug
on log_user = ug.ug_user
join user u
on log_user = u.user_id
join user u2
on log_title = u2.user_name
join user_groups ug2
on u2.user_id = ug2.ug_user
where ug.ug_group = 'eliminator'
and log_type = 'block'
and ug2.ug_group in ('sysop', 'bureaucrat', 'patroller', 'autopatrol', 'rollbacker')
and log_timestamp >= date_format(date_sub(now(), interval 30 day), '%Y%m%d000000')
order by log_id desc
*/
SQL

Checking query status...
