Redirects with targets newer than themselves

SQL

USE fawiki_p;
SELECT SRCP.page_title Source, SRCR.rev_comment SourceComment, SRCR.rev_timestamp SourceTime, TRGTP.page_title Target, TRGTR.rev_comment TargetComment, TRGTR.rev_timestamp TargetTime
FROM revision AS SRCR JOIN page AS SRCP ON SRCR.rev_page=SRCP.page_id
  JOIN redirect ON SRCP.page_id=rd_from
  JOIN page AS TRGTP ON rd_title=TRGTP.page_title
  JOIN revision AS TRGTR ON TRGTR.rev_page=TRGTP.page_id
WHERE SRCR.rev_parent_id = 0
AND SRCP.page_namespace = 0
AND SRCP.page_is_redirect = 1
AND rd_namespace = 0
AND TRGTP.page_namespace = 0
AND TRGTP.page_is_redirect = 0
AND TRGTR.rev_parent_id = 0
AND SRCR.rev_timestamp > TRGTR.rev_timestamp
LIMIT 1000;
SQL

Checking query status...
