حذف تصویر

SQL

USE fawiki_p;
SELECT page_title, rev_timestamp#, rev_comment# DISTINCT concat('# [[',REPLACE(page_title,'_',' '),']]')#,rev_timestamp
FROM revision JOIN page
WHERE rev_page=page_id
AND page_namespace = 0
AND (
  rev_user_text='Rezabot'#rev_user=user_id
#  OR rev_user_text='Babaksaeidpour'#rev_user=user_id
#  OR rev_user_text='MammothBot'#rev_user=user_id
  )

AND rev_comment LIKE '%ربات:حذف_تصویر_(۳.۱)_ناموجود%'
#AND rev_comment LIKE '%حذف پیوند تاریخ (سال‌های خورشیدی)%'


AND rev_timestamp > '20180326095804%'
ORDER BY rev_timestamp DESC;
SQL

Checking query status...
