Fork of Existing revisions affected by 折毛 by Lt2818
This query is marked as a draft This query has been published by Lt2818.

SQL

AخA
 
SELECT CONCAT("[[Special:Diff/", revision.rev_id, "|", REPLACE(page.page_title, '_', ' '), "]]") as 版本差异, actor.actor_name as 用户名, revision.rev_timestamp as 时间戳 FROM revision INNER JOIN actor ON revision.rev_actor = actor.actor_id INNER JOIN page ON page.page_id = revision.rev_page WHERE actor.actor_name IN ('Mafalda4144', '折毛') AND revision.rev_timestamp > 20210923000000 AND revision.rev_timestamp < 20220701000000 ORDER BY 时间戳;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query
All SQL code is licensed under CC0 License.

Checking query status...