Untitled query #20021

SQL

SELECT logtemp.log_user_text AS `reviewer`,
  logtemp.log_title AS `page`,
  logtemp.log_timestamp AS `timestamp`
FROM (
  SELECT log_user_text, log_title, log_timestamp
  FROM logging_userindex
  WHERE log_timestamp BETWEEN 20170701044500 AND 20170702044500
  AND log_type = 'patrol'
  AND log_action = 'patrol'
  AND log_namespace = 0
  AND log_user = 161142
  UNION
  SELECT log_user_text, log_title, log_timestamp
  FROM logging_userindex
  WHERE log_timestamp BETWEEN 20170701044500 AND 20170702044500
  AND log_type = 'pagetriage-curation'
  AND log_action = 'reviewed'
  AND log_namespace = 0
  AND log_user = 161142
) logtemp;
SQL

Checking query status...
