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 year(log_timestamp) = 2025

    and ct_tag_id = 640 -- moveToDraft change tag

    group by month

    order by month;

​

select DATE_FORMAT(log_timestamp, "%Y-%m") as month, count(*) as "Usages of MoveToDraft script by patrollers"

    from page

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

    join change_tag on log_id=ct_log_id

    join actor on log_actor=actor_id

    join user_groups on ug_user=actor_user and ug_group="patroller"

    where page_is_redirect=0

    and page_namespace=118

    and year(log_timestamp) = 2025

    and ct_tag_id = 640 -- moveToDraft change tag

    group by month

    order by month;