SQL
AخA
declare @startdate = '2021-01-01 00:00:00';
declare @enddate = '2021-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
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.