Find draftifications of old articles

SQL

/* Find draftifications of old articles */
SELECT *
FROM logging
JOIN page 
  ON logging.log_title = page.page_title
  AND page.page_namespace = 118
INNER JOIN
  (
    SELECT rev_page, MIN(rev_timestamp) as oldest_revision
	FROM revision
    GROUP BY rev_page
    LIMIT 1
  ) AS rev
  ON rev.rev_page = page.page_id
  -- AND rev.oldest_revision < 20190500000000
WHERE logging.log_type = 'move'
  AND logging.log_namespace = 0
  AND page.page_is_redirect = 0
  AND log_params LIKE '%Draft:%'
  -- AND oldest_revision < 20190500000000
ORDER BY logging.log_timestamp DESC
LIMIT 10;

SQL

Checking query status...