SQL
x
use fawiki_p;
select concat("{{کاربر:Ahmad252/پالایه/الگو|", ipb_address, "}}") as کاربر, replace(replace(comment_text, "به طور خودکار توسط پالایهٔ ویرایش بسته شد.",""), "توضیح قانون مطابقت•یافته: ","") as دلیل, "{{بررسی گزارش پالایه|}}" 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 "20210106000000" and "20210107000000"
and ipb_expiry > "20210107000000"
and ipb_address != ""
order by کاربر desc;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.