OTRS restores and their delay

Undeletes from a given date, with a comment like OTRS in the log, ordered by the length of time since deletion. This may bear no relationship to how recently an email was received at OTRS.

SQL

USE commonswiki_p;
SELECT LEFT(l.log_title, 50),
comment_text AS Comment,
LEFT(l.log_timestamp, 8) AS UDate,
DATEDIFF(LEFT(MAX(ll.log_timestamp), 8), LEFT(l.log_timestamp, 8)) AS Wait
FROM logging AS l
JOIN (
	SELECT log_timestamp, log_page FROM logging
	WHERE log_action="delete"
	) AS ll ON ll.log_page = l.log_page
JOIN comment_logging ON l.log_comment_id = comment_id
WHERE l.log_timestamp > 20190101000001
AND l.log_timestamp < 20190103000000
AND l.log_action = "restore"
AND l.log_namespace = 6 
AND comment_text LIKE "%OTRS%";

SQL

Checking query status...