deletions to reviews by new page patrollers

SQL

#deletion nominations by patrollers
SELECT log_r.log_user_text, 
	COUNT(CASE log_r.log_action WHEN 'reviewed' THEN 1 END) AS reviews,
	COUNT(CASE log_r.log_action WHEN 'delete' THEN 1 END ) AS deletions, 
    COUNT(CASE log_r.log_action WHEN 'delete' THEN 1 END )/COUNT(CASE log_r.log_action WHEN 'reviewed' THEN 1 END)*100 AS percentage
FROM logging_userindex log_r 
WHERE log_r.log_timestamp >= NOW() - INTERVAL 360 DAY
AND log_r.log_namespace = 0 
AND log_r.log_type = 'pagetriage-curation'
AND log_r.log_action IN ('reviewed','delete')
AND log_user IN (SELECT ug_user FROM `user_groups` WHERE ug_group = 'patroller')
GROUP BY log_r.log_user_text
ORDER BY percentage DESC
SQL

Checking query status...
