Untitled query #30859

SQL

#SELECT d.reviewer, d.deletions, r.reviews
#FROM
#	(
      SELECT log_d.log_user_text, COUNT(log_d.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 ) AS d
#	UNION 
#	(SELECT log_r.log_user_text , count(log_r.log_title) 
#    	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) AS r
#GROUP BY d.reviewer
#ORDER BY d.deletions DESC;
SQL

Checking query status...
