Temp - Quarry

SQL

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

Checking query status...
