select concat ("https://en.wikipedia.org/wiki/Draft:", page_title) as page_title,

    log_timestamp, actor_name

    from page

    join logging on page_id = log_page and log_type='move'

    join actor on log_actor=actor_id

    where page_is_redirect=0

    and page_namespace=118

    and page_title like "Draft:%"

    and log_timestamp > date_add(now(), interval -30 day)

    order by log_timestamp desc;