pmp non-patrolled undone edits in the last 24 hrs

SQL

USE fawiki_p;
SELECT page_title, rev_user_text, rev_comment, rev_timestamp
FROM page JOIN revision AS rv ON rv.rev_page = page_id
AND page_namespace = 0
AND rv.rev_comment LIKE '%خنثی‌سازی_ویرایش%توسط%'

AND rev_user IN (
  SELECT ug_user
  FROM user_groups
  WHERE (
    ug_group = 'bureaucrat'
    OR ug_group = 'sysop'
    OR ug_group = 'patroller'
  )
)
AND rv.rev_page NOT IN (
  SELECT rev_page
  FROM page JOIN revision ON page_id = 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 30 DAY < rev_timestamp
#AND CURRENT_TIMESTAMP - rev_timestamp < 00000001000000;
/*AND rev_timestamp > '20171020000000'
AND rev_timestamp < '20171029000000'*/
GROUP BY rv.rev_id
ORDER BY rev_user_text;
SQL

Checking query status...
