recent MERGES of items on Wikidata

Fork of recent MERGES of items on Wikidata by Karl Oblique

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 
	redirect.rd_from, redirect.rd_title, sourcechange.rc_last_oldid as leftdata,
    targetchange.rc_last_oldid as rightdata
FROM redirect 
JOIN recentchanges AS sourcechange ON redirect.rd_from = sourcechange.rc_cur_id
JOIN recentchanges AS targetchange ON redirect.rd_title = targetchange.rc_title
WHERE redirect.rd_namespace = ''
    AND sourcechange.rc_new_len - sourcechange.rc_old_len < - 1000
	AND targetchange.rc_timestamp < sourcechange.rc_timestamp
GROUP BY redirect.rd_from, redirect.rd_title, sourcechange.rc_timestamp, targetchange.rc_timestamp LIMIT 2;

SQL

Checking query status...