/* 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;