percentage kept articles in deletion nominations by patrollers

SQL

SELECT l.log_user_text, 
  COUNT(l.log_title) AS nominated, 
  COUNT(l.page_title) AS kept, 
  COUNT(l.page_title)/COUNT(l.log_title)*100 AS percentage
FROM (
  SELECT DISTINCT log_user_text, log_title, page_title
  FROM logging_userindex
  LEFT JOIN page ON log_page = page_id
  WHERE log_namespace = 0
  AND log_type = 'pagetriage-curation'
  AND log_user IN (
    SELECT ug_user 
    FROM `user_groups` 
    WHERE ug_group = 'patroller'
  ) OR log_user_text IN ('Vexations')
  AND log_action = 'delete'
  AND log_timestamp BETWEEN (NOW() - INTERVAL 372 DAY)  AND (NOW() - INTERVAL 7 DAY)
) AS l
GROUP BY log_user_text
#HAVING nominated > 10
ORDER BY percentage DESC

SQL

Checking query status...