Untitled query #36838

SQL

USE fawiki_p;
SELECT distinct log_title, REGEXP_SUBSTR (log_params,'s:8:"([0-9]+)"',1)   ,log_params,actor_name
    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 limit 10;
SQL

Checking query status...
