Untitled query #36838

SQL

USE fawiki_p;
SELECT distinct log_title,rev_id,rev_page,actor_name, log_id ,log_type ,log_action , log_timestamp , log_actor , log_namespace , log_title, log_page , log_comment_id , log_params , log_deleted
    FROM actor JOIN logging ON log_actor = actor_id Join  revision on log_page=rev_page LEFT JOIN user_groups ON log_actor = 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 1 DAY <log_timestamp
    GROUP BY log_title;
SQL

Checking query status...
