recent MERGES of items on Wikidata

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_timestamp, 
    recentchanges.rc_source, recentchanges.rc_patrolled, 
	recentchanges.rc_old_len, recentchanges.rc_new_len, 
    recentchanges.rc_id, rc_last_oldid,
	actor.actor_name, comment.comment_text 
FROM recentchanges 
	JOIN slots ON recentchanges.rc_last_oldid = slots.slot_revision_id 
    	JOIN content ON slots.slot_content_id = content.content_id 
	JOIN comment ON recentchanges.rc_comment_id = comment.comment_id
	JOIN actor ON recentchanges.rc_actor = actor.actor_id 
WHERE rc_old_len > 1000 AND rc_new_len < 400 ORDER BY recentchanges.rc_timestamp DESC LIMIT 20;

SQL

Checking query status...