Untitled query #30859

SQL

SELECT log_user_text AS reviewer, COUNT(log_d.log_title) AS deletions, count(log_r.log_title)
	FROM logging_userindex log_d
		WHERE log_d.log_type = 'pagetriage-curation'
		AND log_d.log_action = 'delete'
		AND log_d.log_timestamp >= NOW() - INTERVAL 30 DAY
		AND log_d.log_namespace = 0
	UNION 
	FROM logging_userindex log_r
		WHERE log_r.log_type = 'pagetriage-curation'
		AND log_r.log_action = 'review'
		AND log_r.log_timestamp >= NOW() - INTERVAL 30 DAY
		AND log_r.log_namespace = 0
GROUP BY reviewer
ORDER BY deletions DESC;
SQL

Checking query status...
