Drafts with the same title as deleted articles in mainspace but the reason is not R2

SQL

SELECT 
    p.page_title AS draft_title,
    l.log_timestamp AS deletion_timestamp,
    c.comment_text AS deletion_comment
FROM page p
JOIN logging_userindex l ON REPLACE(p.page_title, 'Draft:', '') = l.log_title
LEFT JOIN comment_logging c ON c.comment_id = l.log_comment_id
WHERE p.page_namespace = 118  -- Draft namespace
    AND l.log_type = 'delete'
    AND l.log_action = 'delete'
    AND l.log_namespace = 0   -- Main namespace
    AND p.page_is_redirect = 0
    AND c.comment_text NOT LIKE '[[WP:CSD#R2|R2]]%'
ORDER BY l.log_timestamp DESC
LIMIT 1000;

SQL

Checking query status...