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 loging_userindex.*
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_text = 'Flooded with them hundreds'
AND log_action = 'delete'
AND log_timestamp > NOW() - INTERVAL 360 DAY
#GROUP BY log_user_text
#ORDER BY COUNT(*)

SQL

Checking query status...