I want to get the HTML source of an old version of an article from the version history without restoring it. I can only seem to get a rendered preview or a change list in HTML from the compare option.
Is this possible?
Revisions are stored in the
#__ucm_content table. The version number is the
core_version field. If you want, for example, to get the body of the 2nd reversion of the article with ID 123, you issue the following query:
SELECT `core_body` FROM `#__ucm_content` WHERE `core_content_item_id` = '123' AND `core_version` = 2;