use enwiki; select left(rev_timestamp, 6), count(*) from revision left join revision_actor_temp on revactor_rev=rev_id left join actor on revactor_actor=actor_id left join user on actor_user=user_id left join revision_comment_temp on revcomment_rev=rev_id left join comment on revcomment_comment_id=comment_id left join page on rev_page=page_id where user_name='WikiCleanerBot' and comment_text like '%Internal link written as an external link%' and rev_timestamp>'2019' group by left(rev_timestamp, 6)