Untitled query #54333

SQL

SELECT log_timestamp, log_actor, log_namespace, log_title, comment_text FROM revision
JOIN page ON page_id = rev_page
JOIN logging ON log_timestamp = rev_timestamp AND log_actor = rev_actor
LEFT JOIN comment ON log_comment_id = comment_id
WHERE log_type = 'move' AND page_title = 'AAA' AND page_namespace = 0
ORDER BY log_timestamp DESC;

SELECT rev_timestamp, rev_actor, page_namespace, page_title FROM revision
JOIN page ON page_id = rev_page
WHERE page_title = 'AAA' AND page_namespace = 0
LIMIT 1;
SQL

Checking query status...
