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:%'
ORDER BY logging.log_timestamp DESC
LIMIT 10;

SQL

Checking query status...