recentchanges patrol status

SQL

USE zhwiki_p;
SELECT create_log.log_title, ug_group, patrol_log.log_id
FROM
(
  SELECT *
  FROM logging
  WHERE log_timestamp < 20190615000000
  	AND log_timestamp > 20190515000000
    AND log_type = 'create'
    AND log_namespace = 0
  ORDER BY log_timestamp DESC
) create_log

LEFT JOIN page
ON log_namespace = page_namespace AND log_title = page_title

LEFT JOIN actor
ON log_actor = actor_id

LEFT JOIN (
  SELECt *
  FROM user_groups
  WHERE ug_group IN ('autoreviewer', 'sysop', 'patroller')
) user_groups
ON actor_user = ug_user

LEFT JOIN (
  SELECT *
  FROM logging
  WHERE log_timestamp > 20190515000000
    AND log_type = 'patrol'
    AND log_namespace = 0
) AS patrol_log
ON patrol_log.log_type = 'patrol'
  AND patrol_log.log_namespace = create_log.log_namespace
  AND patrol_log.log_title = create_log.log_title

WHERE page_id IS NOT NULL
  AND page_is_redirect = 0
SQL

Checking query status...
