Top users of MoveToDraft (1w)

SQL

select DATE_FORMAT(log_timestamp, "%Y-%m") as month, count(*) as "Usages of MoveToDraft script"
	from page
    join logging on page_id = log_page and log_type='move'
    join change_tag on log_id=ct_log_id
    where page_is_redirect=0
    and page_namespace=118
    and log_timestamp > date_add(now(), interval -365 day)
    and ct_tag_id = 640 -- moveToDraft change tag
    group by month
    order by month
;
select actor_name, count(*) as c, concat ("https://en.wikipedia.org/wiki/Draft:", page_title) as page_title, log_timestamp, comment_text
	from page
    join logging on page_id = log_page and log_type='move'
    join actor on log_actor=actor_id
    join change_tag on log_id=ct_log_id
    join comment on log_comment_id=comment_id
    where page_namespace=118
    and log_timestamp > date_add(now(), interval -7 day)
    and ct_tag_id = 640 -- moveToDraft change tag
    group by actor_name
    order by c desc;
SQL

Checking query status...
