The SQL to get all/lastest bodycontent of a page

[Normann P_ Nielsen _Netic_]

What is the SQL from a known page id?

This:

SELECT bodycontentid FROM bodycontent WHERE contentid IN (SELECT contentid FROM content WHERE contenttype = 'PAGE' and pageid=238805062);

Returns 0 and this:

SELECT bodycontentid FROM bodycontent WHERE contentid IN (SELECT contentid FROM content WHERE pageid=238805062);

returns 15 - all stuff except the page. The page has 75 versions.

[John Funk]

Hi Normann,

Since no one has responded yet, you probably want to open a support ticket with Atlassian to get their feedback:

https://support.atlassian.com/contact/#/