deletions to reviews by new page patrollers

This query is marked as a draft This query has been published by Vexations.

This ignores deletion nomination that were not done via page curation

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
#    SUM(log_r.log_action = 'deleted') AS deletions,
FROM logging_userindex log_r 
WHERE log_r.log_timestamp >= NOW() - INTERVAL 1 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')

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...