Commons files re-created after previous F10 deletion

SQL

SELECT DISTINCT CONCAT('https://commons.wikimedia.org/wiki/File:', rc.rc_title) AS 'File', TIMESTAMP(rc.rc_timestamp) AS 'Re-created at'
FROM recentchanges_userindex rc
INNER JOIN logging_logindex l ON l.log_type = 'delete' AND l.log_action = 'delete' AND rc.rc_title = l.log_title AND rc.rc_namespace = l.log_namespace
INNER JOIN comment_logging c ON c.comment_id = l.log_comment_id
INNER JOIN page p ON rc.rc_title = p.page_title AND rc.rc_namespace = p.page_namespace
WHERE rc.rc_log_type = 'upload' AND rc.rc_log_action = 'upload'
AND rc.rc_namespace = 6
AND c.comment_text LIKE '%F10%'
ORDER BY rc.rc_timestamp DESC;

SQL

Checking query status...