mysql> SELECT * FROM revision JOIN page ON rev_page = page_id WHERE rev_id = 15875989\G *************************** 1. row *************************** rev_id: 15875989 rev_page: 14276593 rev_text_id: 15875989 rev_comment: Help! rev_user: 88558 rev_user_text: Jaberwocky6669 rev_timestamp: 20050626195604 rev_minor_edit: 1 rev_deleted: 0 rev_len: NULL rev_parent_id: NULL page_id: 14276593 page_namespace: 4 page_title: Village_pump_(assistance) page_restrictions: page_counter: 0 page_is_redirect: 0 page_is_new: 0 page_random: 0.643900508559 page_touched: 20100201225351 page_latest: 254385357 page_len: 2020 mysql> SELECT * FROM archive WHERE ar_title = 'Village_pump_(assistance)' AND ar_rev_id = 15875989 AND ar_namespace = 4\G *************************** 1. row *************************** ar_namespace: 4 ar_title: Village_pump_(assistance) ar_user: 88558 ar_user_text: Jaberwocky6669 ar_timestamp: 20050626195604 ar_minor_edit: 1 ar_flags: ar_rev_id: 15875989 ar_len: NULL ar_page_id: 1099394 ar_parent_id: NULL