This query is marked as a draft This query has been published by Matěj Suchánek.

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.

Checking query status...