Untitled query #54333

SQL

SELECT revision.rev_timestamp, actor_name, log_namespace, log_title, comment_text, log_params, log_id FROM revision qb
JOIN page ON page_id = rev_page
# log entry might have a larger timestamp than the revision entry since it's added after
JOIN (
  SELECT log_namespace, log_title, log_params, log_id FROM logging
  WHERE log_type = 'move' AND log_actor = qb.rev_actor AND log_timestamp >= qb.rev_timestamp LIMIT 1
) AS logging

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...
