recent MERGES of items on Wikidata

This query is marked as a draft This query has been published by Karl Oblique.

This identifies item merges on wikidata bei the change in size and total size of the rev's result (< 400, which is so rough a guess, I'm not entirely sure about the units. But probably bytes). It includes QID, username, comment, and a few more tidbits I found relevant.

SQL

SELECT latest.rev_page, latest.rev_text_id, previous.rev_text_id, 
latest.rev_comment, latest.rev_user_text, latest.rev_actor, latest.rev_timestamp,
latest.rev_len, previous.rev_len 
FROM revision as latest join revision as previous 
ON latest_rev_parent_id = previous.rev_id LIMIT 20;

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 Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...