[TYPO3-dev] Optimizing last 20 query

[Martin Kutschker]

John Angel schrieb:
> Hi!
> 
> Can this be done faster?
> 
> Here is the SQL query providing last 20 pages under page id "1000":

No, it isn't. It will return the 20 first content elements on subpages 
of the page with id 1000. The elements will be return unordered, but the 
pages are returned by their creating date.

What's the purpose of the select?

Masi