[TYPO3-english] Get All parents page ids of a page

[Pablo Feldman]

Hi List,

I need to render a content that could be on the current page, or in any of
parents pages of the tree.
For that I want to do something like
'select bodytext from tt_content where pid in (....)'

I cannot find a way to get a list of all parents uids,
A way should be going page by page using the pid of each one to get the
parent, but does not seems to be a very performant,

Any Idea?

Thanks in advance