Drafts that also exist as an article, ordered by how similar the size is

SQL

SELECT 
  draft.page_title AS draft_title,
  draft.page_id AS draft_id,
  article.page_id AS article_id,
  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,
  ABS(article_text.old_len - draft_text.old_len) AS length_difference
FROM page AS draft
JOIN page AS article 
  ON REPLACE(draft.page_title, 'Draft:', '') = article.page_title
-- Get latest revision of draft
JOIN revision AS draft_rev
  ON draft.page_id = draft_rev.rev_page
  AND draft_rev.rev_id = (
    SELECT MAX(rev_id)
    FROM revision
    WHERE rev_page = draft.page_id
  )
-- Get draft text
JOIN text AS draft_text
  ON draft_rev.rev_text_id = draft_text.old_id
-- Get latest revision of article  
JOIN revision AS article_rev
  ON article.page_id = article_rev.rev_page
  AND article_rev.rev_id = (
    SELECT MAX(rev_id)
    FROM revision
    WHERE rev_page = article.page_id
  )
-- Get article text
JOIN text AS article_text
  ON article_rev.rev_text_id = article_text.old_id
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 length_difference DESC
LIMIT 10;
SQL

Checking query status...
