percentage kept articles in deletion nominations by patrollers

SQL

#SELECT log_user_text, log_title, page_title, log_namespace, page_namespace, logging_userindex.*
#
#
#SELECT log_user_text, COUNT(log_title) AS nominated, COUNT(page_title) AS kept
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 page_namespace = 0
#AND page_title IS NULL
AND log_user IN (SELECT ug_user FROM `user_groups` WHERE ug_group = 'patroller')  
AND log_action = 'delete'
AND log_timestamp > NOW() - INTERVAL 7 DAY
) AS l
GROUP BY log_user_text
ORDER BY percentage

SQL

Checking query status...