Get all page triage details of a page

SQL

SELECT t1.reviewer, reviews, `last review` FROM
(

  SELECT logtemp.log_user_text AS `reviewer`,
  COUNT(logtemp.log_page) AS `reviews`
  FROM (
  SELECT log_user_text, log_page
  FROM logging_userindex
  JOIN user_groups ON ug_user = log_user
  WHERE log_timestamp BETWEEN 20180708000000 AND NOW()
  AND (
    (log_type = 'pagetriage-curation'  AND log_action = 'reviewed')
    OR (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
  FROM `user`
  JOIN user_groups ON ug_user = user_id
  WHERE ug_group = 'patroller'
  ) logtemp
  GROUP BY reviewer

) t1

LEFT JOIN

(

  SELECT logtemp2.log_user_text AS `reviewer`,
  MAX(logtemp2.log_timestamp) AS `last review`
  FROM (
  SELECT log_user_text, log_timestamp
  FROM logging_userindex
  JOIN user_groups ON ug_user = log_user
  WHERE log_timestamp BETWEEN 20180708000000 AND NOW()
	AND (
        (log_type = 'pagetriage-curation'  AND log_action = 'reviewed')
        OR (log_type = 'patrol'  AND log_action = 'patrol')
      )
  AND ug_group = 'patroller'
  AND log_namespace = 0
  ) logtemp2
  GROUP BY reviewer

) t2
ON t1.reviewer = t2.reviewer
ORDER BY reviews DESC;
SQL

Checking query status...
