Untitled query #30859

SQL

SELECT d.log_user_text, d.log_title, r.log_user_text, r.log_title
FROM
	(
      SELECT log_d.log_user_text, 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 1 DAY
			AND log_d.log_namespace = 0 
            ) AS d
	UNION 
	(
		SELECT log_r.log_user_text , log_r.log_title
    		FROM logging_userindex log_r
			WHERE log_r.log_type = 'pagetriage-curation'
			AND log_r.log_action = 'reviewed'
			AND log_r.log_timestamp >= NOW() - INTERVAL 1 DAY
            AND log_r.log_namespace = 0
             ) AS r
#GROUP BY d.reviewer
#ORDER BY d.deletions DESC;
SQL

Checking query status...
