Untitled query #60229

SQL

SELECT 
	redir.rd_from, redir.rd_title, sourcechange.rc_last_oldid as leftdata,
    targetchange.rc_last_oldid as rightdata
FROM (SELECT redirect.rd_from, redirect.rd_title FROM redirect WHERE redirect.rd_namespace = '' ORDER BY redirect.rd_from DESC  LIMIT 5) as redir  
JOIN recentchanges AS sourcechange ON redir.rd_from = sourcechange.rc_cur_id
JOIN recentchanges AS targetchange ON redir.rd_title = targetchange.rc_title
WHERE sourcechange.rc_new_len - sourcechange.rc_old_len < - 1000
	AND targetchange.rc_timestamp < sourcechange.rc_timestamp
GROUP BY redir.rd_from, redir.rd_title, sourcechange.rc_timestamp, targetchange.rc_timestamp LIMIT 2;
SQL

Checking query status...
