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.