Test query - Quarry

SQL

use fawiki_p;
select log_title as کاربر, replace(comment_text, "به طور خودکار توسط پالایهٔ ویرایش بسته شد. توضیح قانون مطابقت‌یافته:","") as دلیل
from logging
join comment
on log_comment_id = comment_id
join actor
on log_actor = actor_id
join ipblocks
on log_title = ipb_address
where actor_name = "پالایهٔ ویرایش" -- The username that AbuseFilter uses to perform its actions. Please update if the username has changed.
and log_type = "block"
and log_timestamp between "20201207000000" and "20201208000000" -- The day blocks were performed. Should be updated for each report.
and ipb_expiry > "20201208000000"
order by دلیل;
SQL

Checking query status...
