SELECT logtemp.log_user_text AS `reviewer`,

COUNT(logtemp.log_page) AS `reviews`,

MAX(logtemp.log_timestamp) AS `last patrol`

FROM (

SELECT log_user_text, log_page, log_timestamp

FROM logging

JOIN user_groups ON ug_user = log_user

WHERE log_timestamp BETWEEN 20180100000000 AND NOW()

AND log_type = 'pagetriage-curation'

AND log_action = 'reviewed'

AND ug_group = 'patroller'

AND log_namespace = 0

UNION

SELECT log_user_text, log_page, log_timestamp

FROM logging

JOIN user_groups ON ug_user = log_user

WHERE log_timestamp BETWEEN 20180100000000 AND NOW()

AND log_type = 'patrol'

AND log_action = 'patrol'

AND ug_group = 'patroller'

AND log_namespace = 0

UNION

SELECT user_name AS log_user_text, NULL AS log_page, NULL as log_timestamp

FROM `user`

JOIN user_groups ON ug_user = user_id

WHERE ug_group = 'patroller'

) logtemp

GROUP BY reviewer

ORDER BY reviews DESC;