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 دلیل;