select page_id, rev_id, content_address, old_text
from revision
join page on page_latest=rev_id
join slots on slot_revision_id=rev_id
join content on slot_content_id=content_id
left outer join text on old_id=substring(content_address, 4)
-- where rev_page=75373
