SQL
x
USE wikidatawiki_p;
SELECT page_title, rev.rev_id, (parent.rev_len - rev.rev_len) AS delta, rev.rev_timestamp
FROM revision_userindex AS rev
JOIN page ON page_id = rev.rev_page
JOIN actor_revision ON rev.rev_actor = actor_id
JOIN comment_revision ON rev.rev_comment_id = comment_id
JOIN revision AS parent ON parent.rev_id = rev.rev_parent_id
WHERE actor_name = 'MatSuBot'
#AND rev.rev_timestamp BETWEEN '20190216' AND '20200214'
#AND rev.rev_timestamp BETWEEN '20200326' AND '20200419'
#AND rev.rev_timestamp BETWEEN '20200406' AND '20200519'
AND (rev.rev_timestamp BETWEEN '20200708' AND '20200709' OR rev.rev_timestamp BETWEEN '20200701' AND '20200702')
AND parent.rev_len > 1300
AND parent.rev_len - 1300 > rev.rev_len
AND page_namespace = 0
AND comment_text LIKE '%MatSuBot 7%'
/*
AND comment_text LIKE '%add missing labels; cleanup'
AND rev.rev_page NOT IN (
SELECT sub.rev_page FROM revision_userindex AS sub
WHERE sub.rev_timestamp BETWEEN '2020061814' AND '2020061815'
AND sub.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.