# of rollbacks in the last 24hrs (suspicious of vandalism)

SQL

USE fawiki_p;
SELECT page_title, rev_user_text, rev_comment, rev_timestamp
FROM revision JOIN page ON rev_page=page_id
WHERE page_namespace = 0
AND (
  rev_comment LIKE '%واگردان%'
  OR rev_comment LIKE '%برگردان%'
  OR rev_comment LIKE '%_وگ_%'
  OR rev_comment LIKE '%خنثی%'
)
AND (
  rev_comment not LIKE 'ویرایش_%_به_آخرین_تغییری_که_%_انجام_داده_بود_واگردانده_شد'
  and rev_comment not LIKE '%خرابکاری%خنثی‌سازی%توینکل%'
  and rev_comment not LIKE '%خرابکاری%خنثی‌سازی%تل%'
  and rev_comment not LIKE '%خنثی‌سازی%به_آخرین_نسخهٔ%توینکل%'
)
AND CURRENT_TIMESTAMP - rev_timestamp < 00000001000000;

SQL

Checking query status...