Untitled query #54333

SQL

/*
SELECT revision.rev_timestamp, actor_name, log_namespace, log_title, comment_text, log_params, log_id 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 logging ON log_actor = rev_actor AND log_timestamp = rev_timestamp
JOIN revision AS revision_parent ON revision_parent.rev_id = revision.rev_parent_id
# make sure to only select *null* edits inserted when the page is moved
WHERE log_type = 'move' AND page_namespace = 0 AND page_title = 'Main_Page' AND revision.rev_len = revision_parent.rev_len
ORDER BY log_timestamp DESC
*/
SELECT * FROM revision
JOIN page ON page_id = rev_page
JOIN revision AS revision_parent ON revision_parent.rev_id = revision.rev_parent_id
WHERE page_namespace = 0 AND page_title = 'Main_Page' AND revision.rev_len = revision_parent.rev_len;


SELECT * FROM logging
LEFT JOIN comment ON log_comment_id = comment_id
LEFT JOIN actor ON log_actor = actor_id
WHERE log_type = 'move' AND log_timestamp >= 20080204011120 AND log_actor = 35515
LIMIT 1;
SQL

Checking query status...
