Fa WP eliminator action review

SQL

use fawiki_p;
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...
