Unreviewed redirects grouped by target

SQL

select concat ("https://en.wikipedia.org/wiki/Draft:", page_title) as page_title, actor_name, log_timestamp, comment_text, count(*) as c
	from page
    join logging on page_id = log_page and log_type='move'
    join actor on log_actor=actor_id
    join comment on log_comment_id=comment_id
    left 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 -7 day)
    and comment_text like "%User:Evad37/MoveToDraft.js%"
    and ct_tag_id = 640 -- moveToDraft change tag
    group by actor_name
    order by c desc;

SQL

Checking query status...