T217512 - Quarry

SQL

USE wikidatawiki_p;
SELECT * FROM revision WHERE rev_page IN (SELECT page_id FROM page WHERE page_title = 'Q805046' AND page_namespace = 0) ORDER BY rev_timestamp DESC;
/*
SELECT new.rev_id, new.rev_timestamp, new.rev_page, new.rev_comment, new.rev_user_text, new.rev_len
FROM revision_userindex AS new JOIN revision_userindex AS old
WHERE new.rev_user_text = 'MatSuBot' AND old.rev_user_text = 'MatSuBot'
AND new.rev_len = old.rev_len AND new.rev_parent_id = old.rev_id
AND new.rev_comment LIKE '%wbmergeitems-from:%'
AND new.rev_timestamp > 20170000000000;*/
SQL

Checking query status...
