SQL
AخA
set @startdate:='2019-12-01 00:00:00';
set @enddate:= DATEADD(month,2,@startdate);/*'2020-03-01 00:00:00';*/
with c as (select comment_id from `comment` where comment_text like '%WP:DATED%'), 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 distinct CONCAT('<a href="https://en.wikipedia.org/wiki/User:',REPLACE(actor_name," ","_"),'">') AS actor_name
from rev
join c on rev_comment_id=comment_id
join actor on rev_actor=actor_id;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.