USE fawiki_p;

SELECT  log_title, REGEXP_SUBSTR (REGEXP_SUBSTR (log_params,'s:8:"4::curid";s:8:"([0-9]+)"') ,'[0-9]{3,}' ) ,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_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;