Find draftifications of old articles

SQL

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

SQL

Checking query status...