SQL
AخA
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;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.