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

Fork of Drafts that also exist as an article and have the same size by Polygnotus

This query is marked as a draft This query has been published by Nemoralis.

SQL

SELECT 
  draft.page_title AS draft_title,
  draft.page_id AS draft_id,
  article.page_id AS article_id,
  draft.page_len AS page_size,
  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, 'Qaralama:', '') = 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
  AND draft.page_len = article.page_len  -- Only exact size matches
ORDER BY draft.page_title
LIMIT 1000;

SQL

Checking query status...