SQL
x
USE fawiki_p;
SELECT page_title, rev_user_text, rev_comment, rev_timestamp, MID(rev_comment,locate('خنثی•سازی_ویرایش',rev_comment)+34,8)
FROM revision AS frstrv JOIN page ON frstrv.rev_page=page_id
WHERE page_namespace = 0
AND frstrv.rev_comment LIKE '%خنثی•سازی_ویرایش%توسط%'
AND MID(rev_comment,locate('خنثی•سازی_ویرایش',rev_comment)+34,8) NOT IN (
SELECT scndrv.rev_id
FROM revision AS scndrv JOIN page ON page_id = scndrv.rev_page JOIN logging ON MID(log_params,locate('curid";s:8:"',log_params)+12,8) = rev_id LEFT JOIN user_groups ON log_user = ug_user AND ug_group = 'bot'
WHERE log_type ='patrol'
AND log_action='patrol'
AND (
log_params LIKE '%auto";i:0;}'
OR log_params LIKE '%0'
)
AND log_title IN (
SELECT page_title
FROM page
WHERE page_namespace = 0
)
AND ug_group IS NULL
)
AND NOW() - INTERVAL 10 HOUR < frstrv.rev_timestamp
#AND CURRENT_TIMESTAMP - rev_timestamp < 00000001000000;
/*AND rev_timestamp > '20140101000000'
AND rev_timestamp < '20171028000000';*/
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.