Portals deleted by RL0919 w/currently-deleted revisions

SQL

SELECT CASE
		WHEN log_title LIKE '%/%' THEN 'Y'
		ELSE 'N'
		END AS is_subpage,
	CONCAT('[[Portal:', log_title, ']]') AS pagename,
	DATE_FORMAT(log_timestamp, '%Y-%m-%d %H:%i:%s') AS timestamp,
	comment_text
FROM logging_userindex
JOIN comment
	ON comment_id = log_comment_id
WHERE log_type = 'delete' AND log_action = 'delete'
	AND log_user = 327763 -- User:RL0919
	AND log_namespace = 100 -- Portal:
	AND EXISTS (SELECT 1
				FROM archive
				WHERE ar_namespace = 100
					AND ar_title = log_title
				LIMIT 1)
ORDER BY is_subpage DESC, log_timestamp ASC;

SQL

Checking query status...