Untitled query #36838

SQL

USE fawiki_p;
SELECT page_title, actor_name, rev_timestamp, log_timestamp
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_actor = ug_user AND ug_group = 'bot'
JOIN actor
  ON ipb_by_actor = actor_id
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 24 HOUR < log_timestamp
#AND CURRENT_TIMESTAMP - log_timestamp < 00000001000000;
SQL

Checking query status...
