USE fawiki_p;

SELECT actor_name, COUNT(log_id) cnt

    FROM actor JOIN logging ON log_actor = actor_id 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 actor_name

    ORDER BY cnt DESC;