Redirects with targets newer than themselves

SQL

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
AND NOT EXISTS (
  SELECT null
  FROM revision AS TRGTROLDER
  WHERE TRGTROLDER.rev_page = TRGTR.rev_page
  AND TRGTROLDER.rev_parent_id = 0
  AND TRGTROLDER.rev_timestamp < TRGTR.rev_timestamp
)
AND SRCR.rev_user_text <> TRGTR.rev_user_text
#LIMIT 100;
SQL

Checking query status...
