Untitled query #54333

SQL

SELECT revision.rev_id, (
  SELECT log_namespace, log_title, log_params, log_id FROM logging
  WHERE log_type = 'move' AND log_actor = revision.rev_actor AND log_timestamp >= revision.rev_timestamp LIMIT 1
)
FROM revision

JOIN page ON page_id = rev_page

# log entry might have a larger timestamp than the revision entry since it's added after


JOIN revision AS revision_parent ON revision_parent.rev_id = revision.rev_parent_id

# LEFT JOIN comment ON log_comment_id = comment_id
# LEFT JOIN actor ON log_actor = actor_id

# make sure to only select *null* edits inserted when the page is moved
WHERE page_namespace = 0 AND page_title = 'Main_Page' AND revision.rev_len = revision_parent.rev_len
ORDER BY log_timestamp DESC
SQL

Checking query status...
