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 recentchanges.rc_title, recentchanges.rc_old_len, recentchanges.rc_new_len, slots.*, content.* from recentchanges join slots
ON recentchanges.rc_last_oldid = slots.slot_revision_id JOIN content ON slots.content_id = content.content_id WHERE rc_old_len > 10000 AND rc_new_len < 300 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...