If I have a rev_content_id, how do I get the actual content? The only way I see to join the revision and content tables is on content_sha1, but that's not indexed.
Topic on Talk:Quarry
The Wiki Replica databases do not store contents of revisions or pages. Page content must be retrieved from the MediaWiki Action API which is not integrated into Quarry.