........ - Quarry

SQL

USE fawiki_p;
SELECT page_title, rev_user, rev_comment, rev_timestamp
FROM revision JOIN page ON rev_page=page_id
WHERE page_namespace = 0
AND rev_id IN (
  
  SELECT MID(log_params,locate('curid";s:8:"',log_params)+12,8)
FROM logging 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 log_timestamp > '20171029010000'
AND log_timestamp < '20171030010000'  
  
  
)
SQL

Checking query status...
