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
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.
SQL

Checking query status...
