SQL
AخA
with c as (select comment_id from `comment` where comment_text like '%WP:DATED%' limit 10), rev (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 ('2021-03-01 00:00:00'))
Select rev_actor
from rev
join c on rev_comment_id=comment_id;
/*inner 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.