deletions to reviews by new page patrollers

SQL

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,
    RANK() OVER (PARTITION BY log_r.log_action ORDER BY reviews) AS rank, 

FROM logging_userindex log_r 
WHERE log_r.log_timestamp >= NOW() - INTERVAL 360 DAY
AND log_r.log_namespace = 0 
#AND log_r.log_user_text = 'Vexations'
AND log_r.log_type = 'pagetriage-curation'
AND log_r.log_action IN ('reviewed','delete')
GROUP BY log_r.log_user_text
ORDER BY percentage DESC
SQL

Checking query status...
