Drafts that also exist as an article and have the same size

SQL

SELECT 
  draft.page_title AS draft_title,
  draft.page_id AS draft_id,
  article.page_id AS article_id,
  draft.page_len AS draft_size,
  article.page_len AS article_size,
  ABS(draft.page_len - article.page_len) AS size_difference,
  CONCAT('https://en.wikipedia.org/wiki/Draft:', REPLACE(draft.page_title, ' ', '_')) AS draft_url,
  CONCAT('https://en.wikipedia.org/wiki/', REPLACE(article.page_title, ' ', '_')) AS article_url
FROM page AS draft
JOIN page AS article 
  ON REPLACE(draft.page_title, 'Draft:', '') = article.page_title
WHERE draft.page_namespace = 118  -- Draft namespace
  AND article.page_namespace = 0   -- Main namespace
  AND draft.page_is_redirect = 0   -- Exclude redirects
  AND article.page_is_redirect = 0 -- Exclude redirects
ORDER BY size_difference ASC     -- Show most similar sizes first
LIMIT 1000;
SQL

Checking query status...
