[TYPO3-dev] Use of subqueries

[Martin Kutschker]

Bernhard Kraft schrieb:
> 
> It depends on what you want to achieve. In many cases it is also
> possible to avoid subqueries by clever use of "JOIN" or "LEFT JOIN".

And be sure to check the output of EXPLAIN for both queries. Depending on your query, your indices
and the number of rows in the tables one version may be faster. I don't think that sub-queries are
slower in all circumstances.

Masi