enwiki list of users with WP:PEACOCK in their edit summaries

SQL

set @startdate:='2020-12-01 00:00:00';
set @enddate:= DATE_ADD(@startdate, INTERVAL 12 MONTH);/*'2020-03-01 00:00:00';*/
with c as (select comment_id from `comment` where comment_text like '%WP:PEACOCK%'), rev as (SELECT rev_actor, rev_comment_id FROM revision JOIN page ON page_id = rev_page WHERE page_namespace = 0 AND page_is_redirect = 0 AND rev_timestamp > TIMESTAMP(@startdate) and rev_timestamp < TIMESTAMP(@enddate))
                                                                                        
/*Select distinct actor_name*/
select  CONCAT('<a href="https://en.wikipedia.org/wiki/User:',REPLACE(actor_name," ","_"),'">',actor_name,'</a>') AS  name, Count(actor_name) As theCount
from rev
join c on rev_comment_id=comment_id
join actor on rev_actor=actor_id
GROUP By actor_name;

SQL

Checking query status...