/* Find draftifications of old articles */

SELECT log_params

FROM logging_logindex

JOIN page 

  ON 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 log_type = 'move'

  AND log_namespace = 0

  AND page.page_is_redirect = 0

  AND rev.page_created_at < 20191200000000

  AND log_params LIKE '%Draft:%'

ORDER BY log_timestamp DESC

LIMIT 30;