pmp non-patrolled edits MADE in the last 24 hrs

SQL

USE fawiki_p;
SELECT page_title, rev_user_text, rev_comment, ug_group
FROM revision AS rv JOIN page ON rv.rev_page = page_id JOIN user_groups ON rev_user = ug_user
AND page_namespace = 0

AND rev_user NOT IN (
  SELECT ug_user
  FROM user_groups
  WHERE (
    ug_group = 'bot'
    OR ug_group = 'autopatrolled'
  )
  
  
)


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 rev_timestamp > '20171029100000'
AND rev_timestamp < '20171029103000'
SQL

Checking query status...
