USE fawiki_p;

SELECT page_title, rev_user_text, rev_comment, rev_timestamp

FROM page JOIN revision AS rv ON rv.rev_page = page_id

AND page_namespace = 0

AND rev_user NOT IN (

  SELECT ug_user

  FROM user_groups

  WHERE (

    ug_group = 'autopatrolled'

    OR ug_group = 'bureaucrat'

    OR ug_group = 'sysop'

    OR ug_group = 'bot'

    OR ug_group = 'eliminator'

    OR ug_group = 'patroller'

    OR ug_group = 'botadmin'

  )

)

AND rv.rev_page NOT IN (

  SELECT rev_page

  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_user = 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 24 HOUR < rev_timestamp

#AND CURRENT_TIMESTAMP - rev_timestamp < 00000001000000;

/*AND rev_timestamp > '20171027000000'

AND rev_timestamp < '20171028000000'*/

GROUP BY rv.rev_id;