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

WITH a as (SELECT 
	recentchanges.rc_title, recentchanges.rc_timestamp AS source_timestamp, 
    recentchanges.rc_source, recentchanges.rc_patrolled, 
	recentchanges.rc_old_len, recentchanges.rc_new_len, 
    recentchanges.rc_id, recentchanges.rc_last_oldid, redirect.rd_title AS target_title,
	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 
    JOIN redirect ON recentchanges.rc_cur_id = redirect.rd_from
WHERE recentchanges.rc_old_len > 1000 AND recentchanges.rc_new_len < 400 ORDER BY recentchanges.rc_timestamp DESC LIMIT 20)
SELECT a.* from a join revision ON a.target_title = revision.rev_page 
AND revision.rev_timestamp < a.source_timestamp ORDER BY revision.rev_timestamp DESC LIMIT 1;

SQL

Checking query status...