Untitled query #30859

SQL

SELECT log_d.log_user_text, log_r.log_type, log_d.log_type, log_r.log_action, log_d.log_action #COUNT(log_d.log_title), COUNT(log_r.log_title), COUNT(log_r.log_title)/COUNT(log_d.log_title)
		FROM logging_userindex log_r 
        LEFT JOIN logging_userindex log_d 
        ON log_d.log_id = log_r.log_id
			WHERE log_d.log_type = 'pagetriage-curation'
			#AND log_d.log_action = 'delete' OR NULL
			AND log_d.log_timestamp >= NOW() - INTERVAL 1 HOUR
			AND log_d.log_namespace = 0 
			#AND log_r.log_action = 'reviewed'
#GROUP BY log_d.log_user_text
#ORDER BY COUNT(log_d.log_title) DESC;
SQL

Checking query status...
