Eliminator actions in last week that may be against policies

SQL

set @lastweek = curdate() - interval dayofweek(curdate())+6 day;
set @lastweekts = concat(date_format(@lastweek, '%Y%m%d'), '000000');
select distinct log_id, user_name, ar_namespace, ar_title
from logging
join user_groups on log_user = ug_user
join user on user_id = ug_user
join archive on log_page = ar_page_id -- only works on Labs, not on Quarry
where ug_group = 'eliminator' and log_type = 'delete'
and (log_comment like '%سرشناس%' or log_comment like '%م۷%')
and log_timestamp > @lastweekts;

SQL

Checking query status...