Fork of Temp by Ahmad252
This query is marked as a draft This query has been published by Ahmad252.

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.

Checking query status...