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

SQL

SELECT DISTINCT 
  CONCAT('https://en.wikipedia.org/wiki/', ar.ar_title) as deleted_title,
  CONCAT('https://en.wikipedia.org/wiki/Draft:', p.page_title) as draft_title,
  ar.ar_timestamp as deletion_date,
  comment.comment_text as deletion_reason
FROM archive ar
JOIN page p ON ar.ar_title = p.page_title 
JOIN comment ON ar.ar_comment_id = comment.comment_id
WHERE ar.ar_namespace = 0  -- Main namespace for deleted articles
AND p.page_namespace = 118   -- Draft namespace
ORDER BY ar.ar_timestamp DESC
LIMIT 5;

SQL

Checking query status...